PB cannot compile my embedded ora sql

[Cool Weather]

ENV: PB 9.0.1, Oracle 9i

Here's my statement:

NOTE: getdate() - is a valid userdefined function. What is wrong with my
script? Thanks.

select queue_seq, process_cd, status
INTO :prl_queue_seq, :prs_process_cd, :ls_status
from queues
where (queue_seq, scheduled_dt) in
(SELECT min(queue_seq), min(scheduled_dt)
FROM queues
WHERE Nvl(scheduled_dt, '01-JAN-1900') <= getdate()
and (status IS NULL OR status in ('E', 'P'))
AND queue_cd = :pos_queue_cd ) USING it_transaction ;

[Cool Weather]

Pls disregard this, I hv it fixed. Thanks.

"Cool Weather" <ald...@hotmail.com> wrote in message
news:458c1278$1@forums-1-dub...