DBA Data[Home] [Help]

APPS.AP_INTEREST_INVOICE_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

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: