APPS.AP_VOID_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 208: FROM ap_invoice_payments_all aip,

204:
205: -- bug9441420
206: CURSOR Prepay_Appl IS
207: SELECT DISTINCT aid.invoice_id
208: FROM ap_invoice_payments_all aip,
209: ap_invoice_distributions_all aid_prepay,
210: ap_invoices_all ai_prepay,
211: ap_invoice_distributions_all aid
212: WHERE aip.check_id = P_Check_ID

Line 525: ap_invoice_payments_all aip

521: aps.last_update_date = SYSDATE,
522: aps.amount_remaining = 0
523: WHERE aps.invoice_id IN (SELECT related_invoice_id
524: FROM ap_invoice_relationships air,
525: ap_invoice_payments_all aip
526: WHERE aip.check_id = P_Check_Id
527: AND air.related_invoice_id = aip.invoice_id
528: AND nvl(aip.reversal_flag, 'N') <> 'Y')
529: RETURNING aps.invoice_id

Line 558: ap_invoice_payments_all AIP

554: AI.pay_curr_invoice_amount = 0 --bug5631957
555: WHERE AI.invoice_id IN
556: (SELECT AIR.related_invoice_id
557: FROM ap_invoice_relationships AIR,
558: ap_invoice_payments_all AIP
559: WHERE AIP.invoice_id = AIR.related_invoice_id
560: AND AIP.check_id = P_Check_Id
561: AND NVL(aip.reversal_flag, 'N') <> 'Y')
562: RETURNING invoice_id

Line 588: ap_invoice_payments_all AIP

584: AIL.base_amount = 0
585: WHERE AIL.invoice_id IN
586: (SELECT AIR.related_invoice_id
587: FROM ap_invoice_relationships AIR,
588: ap_invoice_payments_all AIP
589: WHERE AIP.invoice_id = AIR.related_invoice_id
590: AND AIP.check_id = P_Check_Id
591: AND NVL(aip.reversal_flag, 'N') <> 'Y');
592: