APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 159: FROM ap_invoice_payments_all a, ap_checks_all b

155: CURSOR c_invoice_payment(cp_invoice_payment_id IN NUMBER) IS
156: SELECT a.invoice_payment_id, a.check_id, a.amount, a.payment_base_amount, -- a.reversal_flag, reversal_inv_pmt_id,
157: a.org_id, b.status_lookup_code, b.check_date, b.void_date, b.future_pay_due_date,
158: a.accounting_date, a.reversal_inv_pmt_id, discount_taken
159: FROM ap_invoice_payments_all a, ap_checks_all b
160: WHERE a.check_id = b.check_id
161: AND a.invoice_payment_id = cp_invoice_payment_id;
162:
163: ---------------------------- GET_ITEM_LINE_ID ---------------------------

Line 988: FROM ap_invoice_payments_all a, ap_checks_all b

984:
985: CURSOR c_previous_payments_of_inv(cp_invoice_id IN NUMBER, cp_start_date IN DATE) IS
986: SELECT a.invoice_payment_id, a.check_id, a.amount, a.payment_base_amount, a.reversal_flag,
987: a.reversal_inv_pmt_id, a.org_id
988: FROM ap_invoice_payments_all a, ap_checks_all b
989: WHERE a.invoice_id = cp_invoice_id
990: AND a.check_id = b.check_id
991: AND a.creation_date < cp_start_date
992: AND nvl(b.future_pay_due_date, v_today) <= v_today

Line 1032: ap_invoice_payments_all apinvp,

1028: apinvp.check_id,
1029: apinvp.amount,
1030: apinvp.org_id
1031: FROM
1032: ap_invoice_payments_all apinvp,
1033: ap_checks_all apc ,
1034: ap_invoice_distributions_all ainvd ,
1035: jai_rgm_trx_refs jrtr /* second table is used for join just to take IL records */
1036: WHERE