APPS.AP_PURGE_PKG dependencies on PO_PURGE_PO_LIST

Line 222: from po_purge_po_list

218:
219: -- count_pos
220: select count(1)
221: into po_count
222: from po_purge_po_list
223: where double_check_flag = 'Y';
224:
225: if (po_count = 0) then
226:

Line 284: debug_info := 'The PO_PURGE_PO_LIST table contains records. ';

280: end if ; -- req_count
281:
282: else
283:
284: debug_info := 'The PO_PURGE_PO_LIST table contains records. ';
285: Print('Check_no_purge_in_process' || debug_info);
286: Print('Please make sure no purges are running and clear');
287: Print(' this table. Process terminating.');
288:

Line 1268: from po_purge_po_list ppl,

1264: from ap_invoice_distributions ad
1265: where ad.invoice_id = apl.invoice_id
1266: and ad.po_distribution_id is not null
1267: and not exists (select null
1268: from po_purge_po_list ppl,
1269: po_distributions pd
1270: where ppl.po_header_id =
1271: pd.po_header_id
1272: and pd.po_distribution_id =

Line 1286: FROM po_purge_po_list ppl

1282: where ad.invoice_id = apl.invoice_id
1283: AND pd.po_distribution_id=ad.po_distribution_id
1284: and ad.po_distribution_id is not null
1285: and not exists (SELECT null
1286: FROM po_purge_po_list ppl
1287: WHERE ppl.double_check_flag = 'Y'
1288: AND ppl.po_header_id =pd.po_header_id));
1289:
1290: END IF;

Line 2780: from po_purge_po_list

2776: -- get_po_range
2777: select nvl(min(po_header_id),-1),
2778: nvl(max(po_header_id),-1)
2779: into p_po_lower_limit, p_po_upper_limit
2780: from po_purge_po_list
2781: where double_check_flag = 'Y';
2782:
2783: -- get_req_range
2784: select nvl(min(requisition_header_id),-1),