APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 5567: FROM ap_self_assessed_tax_dist_all asatd

5563: WHERE xe.event_id = l_accounting_event_id_list(i)
5564: AND xe.event_status_code <> 'P'
5565: AND xe.application_id = 200
5566: AND NOT EXISTS (SELECT 'No self assessed tax rows exists for this event'
5567: FROM ap_self_assessed_tax_dist_all asatd
5568: WHERE asatd.invoice_id = l_invoice_line_rec.invoice_id
5569: AND asatd.accounting_event_id = xe.event_id)
5570: AND NOT EXISTS (SELECT 'No Invoice rows exist for this event'
5571: FROM ap_invoice_distributions_all aid

Line 8967: From ap_self_assessed_tax_dist_all AID

8963:
8964: --bug9542963
8965: Select count(*)
8966: Into dummy_self
8967: From ap_self_assessed_tax_dist_all AID
8968: Where AID.charge_applicable_to_dist_id = p_invoice_dist_id
8969: And NVL(AID.cancellation_flag, 'N') <> 'Y'
8970: And NVL(AID.reversal_flag, 'N') <> 'Y';
8971:

Line 9141: UPDATE ap_self_assessed_tax_dist_all

9137: RETURNING invoice_line_number BULK COLLECT INTO l_line_number_tab;
9138:
9139: l_debug_info := 'Updating ap_self_assessed_tax_dist';
9140:
9141: UPDATE ap_self_assessed_tax_dist_all
9142: SET distribution_class = 'PERMANENT'
9143: WHERE invoice_id = p_invoice_id
9144: AND invoice_line_number = NVL(p_invoice_line_number, invoice_line_number)
9145: AND distribution_class = 'CANDIDATE';