DBA Data[Home] [Help]

APPS.AP_VOID_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 383: ap_invoice_payments_all aip

379: aps.last_update_date = SYSDATE,
380: aps.amount_remaining = 0
381: WHERE aps.invoice_id IN (SELECT related_invoice_id
382: FROM ap_invoice_relationships air,
383: ap_invoice_payments_all aip
384: WHERE aip.check_id = P_Check_Id
385: AND air.related_invoice_id = aip.invoice_id
386: AND nvl(aip.reversal_flag, 'N') <> 'Y')
387: RETURNING aps.invoice_id

Line 413: ap_invoice_payments_all AIP

409: AI.pay_curr_invoice_amount = 0 --bug5631957
410: WHERE AI.invoice_id IN
411: (SELECT AIR.related_invoice_id
412: FROM ap_invoice_relationships AIR,
413: ap_invoice_payments_all AIP
414: WHERE AIP.invoice_id = AIR.related_invoice_id
415: AND AIP.check_id = P_Check_Id
416: AND NVL(aip.reversal_flag, 'N') <> 'Y')
417: RETURNING invoice_id

Line 440: ap_invoice_payments_all AIP

436: AIL.base_amount = 0
437: WHERE AIL.invoice_id IN
438: (SELECT AIR.related_invoice_id
439: FROM ap_invoice_relationships AIR,
440: ap_invoice_payments_all AIP
441: WHERE AIP.invoice_id = AIR.related_invoice_id
442: AND AIP.check_id = P_Check_Id
443: AND NVL(aip.reversal_flag, 'N') <> 'Y');
444: