APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on PO_DISTRIBUTIONS

Line 3061: FROM po_distributions PDA

3057: tax_recovery_override_flag,
3058: recoverable_tax,
3059: nonrecoverable_tax,
3060: recovery_rate
3061: FROM po_distributions PDA
3062: WHERE PDA.po_header_id IN
3063: ( SELECT po_header_id
3064: FROM po_headers PHA
3065: WHERE PHA.segment1 IN

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 3917: g_debug_msg := ' Deleting records from Archive PO Distributions table for' ||

3913: -- Delete Archived PO Distribution records that may exist
3914: -- --------------------------------------------------------------------
3915: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3916: IF (g_debug_mode = 'Y') THEN
3917: g_debug_msg := ' Deleting records from Archive PO Distributions table for' ||
3918: ' Last Activity Date : ' || g_last_activity_date;
3919: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3920: END IF;
3921:

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;