APPS.FV_FACTS_TRX_REGISTER dependencies on AP_CHECKS_ALL

Line 2542: FROM ap_checks_all apc,

2538: SELECT v.vendor_id vendor_id,
2539: v.vendor_type_lookup_code vendor_type,
2540: fvv.eliminations_id
2541: INTO l_vendor_id,l_vendor_type,l_eliminations_id
2542: FROM ap_checks_all apc,
2543: po_vendors v,
2544: fv_facts_vendors_v fvv
2545: WHERE apc.vendor_id = v.vendor_id
2546: AND apc.check_id = to_number(l_reference_3)

Line 3217: FROM ap_checks_all apc,

3213: DECODE(apc.payment_type_flag,'A',apc.check_date,
3214: NVL(apc.treasury_pay_date, apc.check_date)) check_date,
3215: apip.creation_date,
3216: apip.created_by
3217: FROM ap_checks_all apc,
3218: ap_invoices_all api,
3219: ap_invoice_payments_all apip
3220: WHERE apc.check_id = to_number(p_reference3)
3221: AND api.invoice_id = to_number(p_reference2)

Line 3267: FROM ap_checks_all

3263: -- FROM ar_misc_cash_distributions_all
3264: -- WHERE misc_cash_distribution_id = to_number(l_cash_receipt_hist_id);
3265: CURSOR Pay_Treas_Check IS
3266: SELECT void_date, checkrun_name
3267: FROM ap_checks_all
3268: WHERE check_id = p_reference3;
3269: CURSOR Pay_Treas_Void IS
3270: SELECT creation_date, created_by
3271: FROM ap_invoice_payments_all

Line 3287: FROM ap_checks_all

3283: CURSOR Pay_Pay_Check IS
3284: SELECT void_date,
3285: DECODE(payment_type_flag,'A',check_date,
3286: NVL(treasury_pay_date,check_date)) check_date
3287: FROM ap_checks_all
3288: WHERE check_id = p_reference3;
3289: CURSOR Pay_Pay_Void IS
3290: SELECT NVL(MAX(invoice_payment_id),0)
3291: FROM ap_invoice_payments_all

Line 3307: FROM ap_checks_all apc,

3303: AND apip.invoice_payment_id = p_reference9;
3304: CURSOR Pay_Pay_Non_Void IS
3305: SELECT api.invoice_num, apc.creation_date,
3306: apc.created_by
3307: FROM ap_checks_all apc,
3308: ap_invoices_all api,
3309: ap_invoice_payments_all apip
3310: WHERE apc.check_id = to_number(p_reference3)
3311: AND api.invoice_id = to_number(p_reference2)