2108: -- Check_invoice_Summary
2109: BEGIN
2110: select 'Y'
2111: into range_inserted
2112: from sys.dual
2113: where exists (select null
2114: from ap_history_invoices
2115: where purge_name = p_purge_name
2116: and invoice_id between range_low and range_high);
2257: BEGIN
2258:
2259: select 'Y'
2260: into range_inserted
2261: from sys.dual
2262: where exists (select null
2263: from po_history_vendors vnd
2264: where vnd.purge_name = p_purge_name);
2265:
2355:
2356: -- Check_Chv_Summary
2357: select MAX('Y')
2358: into range_inserted
2359: from sys.dual
2360: where exists (select null
2361: from chv_schedule_items csi,
2362: chv_schedule_headers csh,
2363: chv_history_schedules chs
2433:
2434: -- Check_Chv_Summary_for_CUMs
2435: select MAX('Y')
2436: into range_inserted
2437: from sys.dual
2438: where exists (select null
2439: from chv_cum_periods ccp,
2440: chv_history_cum_periods chcp
2441: where ccp.cum_period_id = chcp.cum_period_id