DBA Data[Home] [Help]

APPS.PER_JOBS_PKG dependencies on DUAL

Line 7: from sys.dual;

3: --
4: procedure get_next_sequence(p_job_id in out nocopy number) is
5: --
6: cursor c1 is select per_jobs_s.nextval
7: from sys.dual;
8: --
9: begin
10: --
11: -- Retrieve the next sequence number for job_id

Line 473: ||'from sys.dual '

469: -- alias ppc. RMF 17-Apr-96.
470: --
471: begin
472: l_sql_text := 'select null '
473: ||'from sys.dual '
474: ||'where exists( select null '
475: ||' from po_position_controls '
476: ||' where job_id = '
477: ||to_char(p_job_id)