APPS.FV_GTAS_TRX_REGISTER dependencies on AP_INVOICE_PAYMENTS_ALL

Line 2428: ap_invoice_payments_all aip

2424: l_reference_4,
2425: l_reference_6
2426: FROM ap_payment_hist_dists aphd,
2427: ap_invoice_distributions_all aid,
2428: ap_invoice_payments_all aip
2429: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
2430: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
2431: AND aip.invoice_payment_id = aphd.invoice_payment_id;
2432: EXCEPTION

Line 2531: ap_invoice_payments_all aip

2527: l_reference_4,
2528: l_reference_6
2529: FROM ap_payment_hist_dists aphd,
2530: ap_invoice_distributions_all aid,
2531: ap_invoice_payments_all aip
2532: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
2533: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
2534: AND aip.invoice_payment_id = aphd.invoice_payment_id;
2535: EXCEPTION

Line 3377: ap_invoice_payments_all apip

3373: apip.creation_date,
3374: apip.created_by
3375: FROM ap_checks_all apc,
3376: ap_invoices_all api,
3377: ap_invoice_payments_all apip
3378: WHERE apc.check_id = to_number(p_reference3)
3379: AND api.invoice_id = to_number(p_reference2)
3380: AND apc.check_id = apip.check_id
3381: AND api.invoice_id = apip.invoice_id;

Line 3425: FROM ap_invoice_payments_all

3421: FROM ap_checks_all
3422: WHERE check_id = p_reference3;
3423: CURSOR Pay_Treas_Void IS
3424: SELECT creation_date, created_by
3425: FROM ap_invoice_payments_all
3426: WHERE check_id = p_reference3
3427: AND invoice_payment_id = (SELECT max(invoice_payment_id)
3428: FROM ap_invoice_payments_all
3429: WHERE check_id = p_reference3);

Line 3428: FROM ap_invoice_payments_all

3424: SELECT creation_date, created_by
3425: FROM ap_invoice_payments_all
3426: WHERE check_id = p_reference3
3427: AND invoice_payment_id = (SELECT max(invoice_payment_id)
3428: FROM ap_invoice_payments_all
3429: WHERE check_id = p_reference3);
3430: CURSOR Pay_Treas IS
3431: SELECT ftc.checkrun_name,
3432: ftc.treasury_doc_date,

Line 3447: FROM ap_invoice_payments_all

3443: WHERE check_id = p_reference3;
3444:
3445: CURSOR Pay_Pay_Void IS
3446: SELECT NVL(MAX(invoice_payment_id),0)
3447: FROM ap_invoice_payments_all
3448: WHERE invoice_id = NVL(p_reference2, 0)
3449: AND check_id = NVL(p_reference3,0)
3450: AND invoice_payment_id > p_reference9;
3451:

Line 3455: FROM ap_invoice_payments_all apip,

3451:
3452: CURSOR Pay_Pay_Void_Values IS
3453: SELECT api.invoice_num, apip.creation_date,
3454: apip.created_by
3455: FROM ap_invoice_payments_all apip,
3456: ap_invoices_all api
3457: WHERE api.invoice_id = NVL(p_reference2, 0)
3458: AND api.invoice_id = apip.invoice_id
3459: AND apip.check_id = NVL(p_reference3,0)

Line 3467: ap_invoice_payments_all apip

3463: SELECT api.invoice_num, apc.creation_date,
3464: apc.created_by
3465: FROM ap_checks_all apc,
3466: ap_invoices_all api,
3467: ap_invoice_payments_all apip
3468: WHERE apc.check_id = to_number(p_reference3)
3469: AND api.invoice_id = to_number(p_reference2)
3470: AND apc.check_id = apip.check_id
3471: AND api.invoice_id = apip.invoice_id;