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 336: -- FROM DUAL;

332: BEGIN
333: --
334: -- SELECT ben_ext_rslt_s.CURRVAL
335: -- INTO l_ext_rslt_id
336: -- FROM DUAL;
337:
338: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
339:
340: RETURN l_ext_rslt_id;

Line 1506: -- to launch individual extract processes

1502:
1503:
1504: -- the follwoing ELSE is for the case when this process is NOT a parent
1505: -- it is in fact one of the threads launched by Penserver Interface Process
1506: -- to launch individual extract processes
1507: ELSE -- IF p_submit_request_y_n = 'N' THEN
1508:
1509: -- This is a child thread, prepare to submit extract processes
1510: l_eff_date := p_eff_date;

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

1897: END IF;
1898:
1899:
1900: debug('p_parent_request_id ' || p_parent_request_id, 20);
1901: -- If parent request id is supplied instead of individual result ids.
1902:
1903: IF p_parent_request_id IS NOT NULL THEN
1904: OPEN csr_get_rsltid(c_get_rsltid=>p_parent_request_id);
1905: LOOP