DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on DUAL

Line 268: FROM DUAL;

264: TO_CHAR (g_effective_date, 'YYYY')
265: ),
266: 'DD-MM-YYYY'
267: )
268: FROM DUAL;
269:
270: l_proc_name VARCHAR2 (60)
271: := g_proc_name
272: || 'set_periodic_run_date';

Line 379: FROM DUAL;

375: ),
376: 'DD-MM-YYYY'
377: )
378: INTO g_effective_start_date
379: FROM DUAL;
380: END IF; -- End if of g_effective_start_date is Null check ...
381: END IF; -- End if of csr_last_run_details not found check ...
382:
383: IF g_effective_start_date > g_effective_end_date

Line 3688: FROM DUAL;

3684: c_column_name,
3685: 'P = Reduced Rate Conts but now Full Rate', 'P',
3686: 'Y = Reduced Rate Conts Current', 'Y'
3687: )
3688: FROM DUAL;
3689:
3690: --
3691:
3692: l_proc_name VARCHAR2 (60)