APPS.PQP_GB_PSI_FUNCTIONS dependencies on DUAL

Line 22: SELECT TO_CHAR(SYSDATE,'SSSSS') INTO t FROM dual;

18: t NUMBER;
19:
20: BEGIN
21:
22: SELECT TO_CHAR(SYSDATE,'SSSSS') INTO t FROM dual;
23:
24: return t;
25:
26: END get_time;

Line 272: -- FROM DUAL;

268: BEGIN
269: --
270: -- SELECT ben_ext_rslt_s.CURRVAL
271: -- INTO l_ext_rslt_id
272: -- FROM DUAL;
273:
274: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
275:
276: RETURN l_ext_rslt_id;

Line 1442: -- to launch individual extract processes

1438:
1439:
1440: -- the follwoing ELSE is for the case when this process is NOT a parent
1441: -- it is in fact one of the threads launched by Penserver Interface Process
1442: -- to launch individual extract processes
1443: ELSE -- IF p_submit_request_y_n = 'N' THEN
1444:
1445: -- This is a child thread, prepare to submit extract processes
1446: l_eff_date := p_eff_date;

Line 1837: -- If parent request id is supplied instead of individual result ids.

1833: END IF;
1834:
1835:
1836: debug('p_parent_request_id ' || p_parent_request_id, 20);
1837: -- If parent request id is supplied instead of individual result ids.
1838:
1839: IF p_parent_request_id IS NOT NULL THEN
1840: OPEN csr_get_rsltid(c_get_rsltid=>p_parent_request_id);
1841: LOOP