APPS.AP_PURGE_PKG dependencies on PO_PURGE_PO_LIST

Line 210: from po_purge_po_list

206:
207: -- count_pos
208: select count(1)
209: into po_count
210: from po_purge_po_list
211: where double_check_flag = 'Y';
212:
213: if (po_count = 0) then
214:

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

268: end if ; -- req_count
269:
270: else
271:
272: debug_info := 'The PO_PURGE_PO_LIST table contains records. ';
273: Print('Check_no_purge_in_process' || debug_info);
274: Print('Please make sure no purges are running and clear');
275: Print(' this table. Process terminating.');
276:

Line 1104: from po_purge_po_list ppl,

1100: from ap_invoice_distributions ad
1101: where ad.invoice_id = apl.invoice_id
1102: and ad.po_distribution_id is not null
1103: and not exists (select null
1104: from po_purge_po_list ppl,
1105: po_distributions pd
1106: where ppl.po_header_id =
1107: pd.po_header_id
1108: and pd.po_distribution_id =

Line 1122: FROM po_purge_po_list ppl

1118: where ad.invoice_id = apl.invoice_id
1119: AND pd.po_distribution_id=ad.po_distribution_id
1120: and ad.po_distribution_id is not null
1121: and not exists (SELECT null
1122: FROM po_purge_po_list ppl
1123: WHERE ppl.double_check_flag = 'Y'
1124: AND ppl.po_header_id =pd.po_header_id));
1125:
1126: END IF;

Line 2525: from po_purge_po_list

2521: -- get_po_range
2522: select nvl(min(po_header_id),-1),
2523: nvl(max(po_header_id),-1)
2524: into p_po_lower_limit, p_po_upper_limit
2525: from po_purge_po_list
2526: where double_check_flag = 'Y';
2527:
2528: -- get_req_range
2529: select nvl(min(requisition_header_id),-1),