APPS.IGI_EXP_HOLDS dependencies on AP_INVOICE_DISTRIBUTIONS

Line 293: FROM ap_invoice_distributions_all

289:
290: CURSOR c_dist_approval_status
291: IS
292: SELECT match_status_flag
293: FROM ap_invoice_distributions_all
294: WHERE invoice_id = p_invoice_id
295: UNION
296: SELECT 'N'
297: FROM ap_invoice_distributions_all

Line 297: FROM ap_invoice_distributions_all

293: FROM ap_invoice_distributions_all
294: WHERE invoice_id = p_invoice_id
295: UNION
296: SELECT 'N'
297: FROM ap_invoice_distributions_all
298: WHERE invoice_id = p_invoice_id
299: AND match_status_flag IS NULL
300: AND EXISTS
301: (SELECT 'There are both untested and tested lines'

Line 302: FROM ap_invoice_distributions_all

298: WHERE invoice_id = p_invoice_id
299: AND match_status_flag IS NULL
300: AND EXISTS
301: (SELECT 'There are both untested and tested lines'
302: FROM ap_invoice_distributions_all
303: WHERE invoice_id = p_invoice_id
304: AND match_status_flag IN ('T','A'));
305:
306:

Line 468: -- For the following CURSOR the ap_invoice_distributions table is used

464: , p_source VARCHAR2
465: , p_calling_sequence VARCHAR2)
466: RETURN BOOLEAN
467: IS
468: -- For the following CURSOR the ap_invoice_distributions table is used
469: -- instead of the ap_invoices table to avoid a mutating table problem.
470: -- This occurs when this package which is called from the trigger
471: -- igi_exp_hold_trx on the ap_invoices table queries the ap_invoices
472: -- table. to avoid this use the ap_invoices_distribution table.

Line 1047: FROM ap_invoice_distributions

1043: -- Bug 2505522
1044: -- Bug 2576238
1045: BEGIN
1046: SELECT SUM(NVL(amount,0)) INTO l_inv_dist_amt
1047: FROM ap_invoice_distributions
1048: WHERE invoice_id = p_invoice_id
1049: AND line_type_lookup_code NOT IN ('AWT')
1050: AND NVL(invoice_includes_prepay_flag, 'Y') = 'Y'
1051: AND prepay_tax_parent_id IS NULL