APPS.AP_INTEREST_INVOICE_PKG dependencies on AP_INVOICE_PAYMENTS

Line 189: | | _payments : Insert AP_INVOICE_PAYMENTS | PAY |

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

Line 480: -- Insert AP_INVOICE_PAYMENTS

476:
477: ---------------------------------------------------------------------------
478: -- Step 7: Case for ALL : for Pay and rev interest invoice
479: -- Call AP_PAY_INVOICE_PKG.ap_pay_insert_invoice_payments :
480: -- Insert AP_INVOICE_PAYMENTS
481: ---------------------------------------------------------------------------
482:
483: ap_pay_invoice_pkg.ap_pay_insert_invoice_payments(
484: P_int_invoice_id,

Line 1850: ap_invoice_payments AIP,

1846: AID.accts_pay_code_combination_id Accts_Pay_Code_Combination_Id,
1847: AID.org_id Org_Id
1848: FROM ap_invoice_distributions AID,
1849: gl_code_combinations GL,
1850: ap_invoice_payments AIP,
1851: ap_invoice_relationships AIR,
1852: ap_lookup_codes ALC
1853: WHERE AIR.related_invoice_id = AID.invoice_id
1854: AND GL.code_combination_id = AID.dist_code_combination_id

Line 1911: ap_invoice_payments_all AIP

1907: APS.amount_remaining = 0
1908: WHERE APS.invoice_id IN
1909: (SELECT AIR.related_invoice_id
1910: FROM ap_invoice_relationships AIR,
1911: ap_invoice_payments_all AIP
1912: WHERE AIP.invoice_payment_id = P_Invoice_Payment_Id
1913: AND AIR.related_invoice_id = AIP.invoice_id)
1914: RETURNING APS.invoice_id
1915: BULK COLLECT INTO l_dbi_key_value_list1;

Line 1942: ap_invoice_payments_all AIP

1938: AI.invoice_distribution_total = 0
1939: WHERE AI.invoice_id IN
1940: (SELECT /*+ UNNEST */ AIR.related_invoice_id
1941: FROM ap_invoice_relationships AIR,
1942: ap_invoice_payments_all AIP
1943: WHERE AIP.invoice_payment_id = P_Invoice_Payment_Id
1944: AND AIR.related_invoice_id = AIP.invoice_id)
1945: RETURNING invoice_id
1946: BULK COLLECT INTO l_dbi_key_value_list2;

Line 1968: ap_invoice_payments_all AIP

1964: AIL.base_amount = 0
1965: WHERE AIL.invoice_id IN
1966: (SELECT /*+ UNNEST */ AIR.related_invoice_id
1967: FROM ap_invoice_relationships AIR,
1968: ap_invoice_payments_all AIP
1969: WHERE AIP.invoice_payment_id = P_Invoice_Payment_Id
1970: AND AIR.related_invoice_id = AIP.invoice_id);
1971:
1972:

Line 1983: ap_invoice_payments aip,

1979: SELECT max(aid.distribution_line_number)
1980: INTO l_max_dist_line_num
1981: FROM ap_invoice_distributions aid,
1982: gl_code_combinations gl,
1983: ap_invoice_payments aip,
1984: ap_invoice_relationships air,
1985: ap_lookup_codes alc
1986: WHERE AIR.related_invoice_id = AID.invoice_id
1987: AND GL.code_combination_id = AID.dist_code_combination_id