APPS.AP_INTEREST_INVOICE_PKG dependencies on AP_INVOICE_PAYMENTS

Line 191: | | _payments : Insert AP_INVOICE_PAYMENTS | PAY |

187: | Step 6: | Call ap_int_inv_insert_ap_pay_sche | PAY |
188: | |
189: +----------+----------------------------------------------------+-------------+
190: | Step 7: | Call AP_PAY_INVOICE_PKG.ap_pay_insert_invoice | |
191: | | _payments : Insert AP_INVOICE_PAYMENTS | PAY |
192: +----------+----------------------------------------------------+-------------+
193:
194: *========================================================================*/
195:

Line 484: -- Insert AP_INVOICE_PAYMENTS

480:
481: ---------------------------------------------------------------------------
482: -- Step 7: Case for ALL : for Pay and rev interest invoice
483: -- Call AP_PAY_INVOICE_PKG.ap_pay_insert_invoice_payments :
484: -- Insert AP_INVOICE_PAYMENTS
485: ---------------------------------------------------------------------------
486:
487: ap_pay_invoice_pkg.ap_pay_insert_invoice_payments(
488: P_int_invoice_id,

Line 1946: ap_invoice_payments AIP,

1942: AID.accts_pay_code_combination_id Accts_Pay_Code_Combination_Id,
1943: AID.org_id Org_Id
1944: FROM ap_invoice_distributions AID,
1945: gl_code_combinations GL,
1946: ap_invoice_payments AIP,
1947: ap_invoice_relationships AIR,
1948: ap_lookup_codes ALC
1949: WHERE AIR.related_invoice_id = AID.invoice_id
1950: AND GL.code_combination_id = AID.dist_code_combination_id

Line 2007: ap_invoice_payments_all AIP

2003: APS.amount_remaining = 0
2004: WHERE APS.invoice_id IN
2005: (SELECT AIR.related_invoice_id
2006: FROM ap_invoice_relationships AIR,
2007: ap_invoice_payments_all AIP
2008: WHERE AIP.invoice_payment_id = P_Invoice_Payment_Id
2009: AND AIR.related_invoice_id = AIP.invoice_id)
2010: RETURNING APS.invoice_id
2011: BULK COLLECT INTO l_dbi_key_value_list1;

Line 2038: ap_invoice_payments_all AIP

2034: AI.invoice_distribution_total = 0
2035: WHERE AI.invoice_id IN
2036: (SELECT /*+ UNNEST */ AIR.related_invoice_id
2037: FROM ap_invoice_relationships AIR,
2038: ap_invoice_payments_all AIP
2039: WHERE AIP.invoice_payment_id = P_Invoice_Payment_Id
2040: AND AIR.related_invoice_id = AIP.invoice_id)
2041: RETURNING invoice_id
2042: BULK COLLECT INTO l_dbi_key_value_list2;

Line 2064: ap_invoice_payments_all AIP

2060: AIL.base_amount = 0
2061: WHERE AIL.invoice_id IN
2062: (SELECT /*+ UNNEST */ AIR.related_invoice_id
2063: FROM ap_invoice_relationships AIR,
2064: ap_invoice_payments_all AIP
2065: WHERE AIP.invoice_payment_id = P_Invoice_Payment_Id
2066: AND AIR.related_invoice_id = AIP.invoice_id);
2067:
2068:

Line 2079: ap_invoice_payments aip,

2075: SELECT max(aid.distribution_line_number)
2076: INTO l_max_dist_line_num
2077: FROM ap_invoice_distributions aid,
2078: gl_code_combinations gl,
2079: ap_invoice_payments aip,
2080: ap_invoice_relationships air,
2081: ap_lookup_codes alc
2082: WHERE AIR.related_invoice_id = AID.invoice_id
2083: AND GL.code_combination_id = AID.dist_code_combination_id