APPS.PO_AP_PURGE_UTIL_PVT dependencies on PO_DISTRIBUTIONS

Line 189: -- The subquery on po_distributions is to make sure that no invoice

185: IF (p_purge_category = PO_AP_PURGE_GRP.G_PUR_CAT_SIMPLE_PO) THEN
186:
187: l_progress := '010';
188:
189: -- The subquery on po_distributions is to make sure that no invoice
190: -- has matched to this PO yet
191:
192: --SQL What: Generate a list of POs that are eligibible for purge
193: --SQL Why: This is the initial list of pos to be purged. There will

Line 247: FROM po_distributions PD

243: AND PPD.last_update_date >
244: p_last_activity_date)))
245: AND NOT EXISTS
246: (SELECT NULL
247: FROM po_distributions PD
248: WHERE PD.po_header_id = PH.po_header_id
249: AND (PD.last_update_date > p_last_activity_date
250: OR
251: EXISTS

Line 334: FROM po_distributions PD

330: AND PPD.last_update_date >
331: p_last_activity_date)))
332: AND NOT EXISTS
333: (SELECT NULL
334: FROM po_distributions PD
335: WHERE PD.po_header_id = PH.po_header_id
336: AND PD.last_update_date > p_last_activity_date)
337: AND NOT EXISTS
338: (SELECT NULL