APPS.FV_GTAS_TRX_REGISTER dependencies on AP_CHECKS_ALL

Line 3071: FROM ap_checks_all apc,

3067: SELECT v.vendor_id vendor_id,
3068: NVL(v.global_attribute4,'N') vendor_type,
3069: SUBSTR(v.global_attribute5,1,3)
3070: INTO l_vendor_id,l_vendor_type,l_eliminations_id
3071: FROM ap_checks_all apc,
3072: po_vendors v
3073: WHERE apc.vendor_id = v.vendor_id
3074: AND apc.check_id = to_number(l_reference_3);
3075: EXCEPTION

Line 3375: FROM ap_checks_all apc,

3371: DECODE(apc.payment_type_flag,'A',apc.check_date,
3372: NVL(apc.treasury_pay_date, apc.check_date)) check_date,
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)

Line 3421: FROM ap_checks_all

3417: WHERE reversal_cash_receipt_hist_id = c_cash_receipt_hist_id;
3418:
3419: CURSOR Pay_Treas_Check IS
3420: SELECT void_date, checkrun_name
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

Line 3442: FROM ap_checks_all

3438: CURSOR Pay_Pay_Check IS
3439: SELECT void_date,
3440: DECODE(payment_type_flag,'A',check_date,
3441: NVL(treasury_pay_date,check_date)) check_date
3442: FROM ap_checks_all
3443: WHERE check_id = p_reference3;
3444:
3445: CURSOR Pay_Pay_Void IS
3446: SELECT NVL(MAX(invoice_payment_id),0)

Line 3465: FROM ap_checks_all apc,

3461:
3462: CURSOR Pay_Pay_Non_Void IS
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)