APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 3191: po_distributions_all PDA,

3187: AND ICH.cc_header_id NOT IN
3188: ( SELECT ICH1.cc_header_id
3189: FROM igc_cc_headers ICH1,
3190: po_headers_all PHA1,
3191: po_distributions_all PDA,
3192: ap_invoice_distributions_all AIDA,
3193: ap_invoices_all AIA1
3194: WHERE /*ICH1.set_of_books_id = g_sob_id
3195: AND ICH1.org_id = g_org_id

Line 5277: FROM po_distributions_all PDA

5273: -- --------------------------------------------------------------------
5274: -- Delete all PO Distribution records for related CC Header IDs.
5275: -- --------------------------------------------------------------------
5276: DELETE
5277: FROM po_distributions_all PDA
5278: WHERE PDA.po_header_id IN
5279: ( SELECT PHA.po_header_id
5280: FROM po_headers_all PHA
5281: WHERE PHA.segment1 IN

Line 5289: g_debug_msg := 'Number Rows Deleted from PO_DISTRIBUTIONS_ALL for CC Header ID : ' ||

5285: )
5286: );
5287:
5288: IF (g_debug_mode = 'Y') THEN
5289: g_debug_msg := 'Number Rows Deleted from PO_DISTRIBUTIONS_ALL for CC Header ID : ' ||
5290: l_cc_header_id || ' SOB ID : ' || g_sob_id || ' is : ' ||
5291: to_char(SQL%ROWCOUNT);
5292: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5293: END IF;