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

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

Line 3687: FROM DUAL;

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