DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on DUAL

Line 2367: from sys.dual

2363: -- Check_invoice_Summary
2364: BEGIN
2365: select 'Y'
2366: into range_inserted
2367: from sys.dual
2368: where exists (select null
2369: from ap_history_invoices
2370: where purge_name = p_purge_name
2371: and invoice_id between range_low and range_high);

Line 2516: from sys.dual

2512: BEGIN
2513:
2514: select 'Y'
2515: into range_inserted
2516: from sys.dual
2517: where exists (select null
2518: from po_history_vendors vnd
2519: where vnd.purge_name = p_purge_name);
2520:

Line 2614: from sys.dual

2610:
2611: -- Check_Chv_Summary
2612: select MAX('Y')
2613: into range_inserted
2614: from sys.dual
2615: where exists (select null
2616: from chv_schedule_items csi,
2617: chv_schedule_headers csh,
2618: chv_history_schedules chs

Line 2692: from sys.dual

2688:
2689: -- Check_Chv_Summary_for_CUMs
2690: select MAX('Y')
2691: into range_inserted
2692: from sys.dual
2693: where exists (select null
2694: from chv_cum_periods ccp,
2695: chv_history_cum_periods chcp
2696: where ccp.cum_period_id = chcp.cum_period_id