DBA Data[Home] [Help]

APPS.AP_INTEREST_INVOICE_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

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: