APPS.FV_FACTS_TRX_REGISTER dependencies on AP_CHECKS_ALL

Line 2408: FROM ap_checks_all apc,

2404: SELECT v.vendor_id vendor_id,
2405: v.vendor_type_lookup_code vendor_type,
2406: fvv.eliminations_id
2407: INTO l_vendor_id,l_vendor_type,l_eliminations_id
2408: FROM ap_checks_all apc,
2409: po_vendors v,
2410: fv_facts_vendors_v fvv
2411: WHERE apc.vendor_id = v.vendor_id
2412: AND apc.check_id = to_number(l_reference_3)

Line 3003: FROM ap_checks_all apc,

2999: DECODE(apc.payment_type_flag,'A',apc.check_date,
3000: NVL(apc.treasury_pay_date, apc.check_date)) check_date,
3001: apip.creation_date,
3002: apip.created_by
3003: FROM ap_checks_all apc,
3004: ap_invoices_all api,
3005: ap_invoice_payments_all apip
3006: WHERE apc.check_id = to_number(p_reference3)
3007: AND api.invoice_id = to_number(p_reference2)

Line 3053: FROM ap_checks_all

3049: -- FROM ar_misc_cash_distributions_all
3050: -- WHERE misc_cash_distribution_id = to_number(l_cash_receipt_hist_id);
3051: CURSOR Pay_Treas_Check IS
3052: SELECT void_date, checkrun_name
3053: FROM ap_checks_all
3054: WHERE check_id = p_reference3;
3055: CURSOR Pay_Treas_Void IS
3056: SELECT creation_date, created_by
3057: FROM ap_invoice_payments_all

Line 3073: FROM ap_checks_all

3069: CURSOR Pay_Pay_Check IS
3070: SELECT void_date,
3071: DECODE(payment_type_flag,'A',check_date,
3072: NVL(treasury_pay_date,check_date)) check_date
3073: FROM ap_checks_all
3074: WHERE check_id = p_reference3;
3075: CURSOR Pay_Pay_Void IS
3076: SELECT NVL(MAX(invoice_payment_id),0)
3077: FROM ap_invoice_payments_all

Line 3093: FROM ap_checks_all apc,

3089: AND apip.invoice_payment_id = p_reference9;
3090: CURSOR Pay_Pay_Non_Void IS
3091: SELECT api.invoice_num, apc.creation_date,
3092: apc.created_by
3093: FROM ap_checks_all apc,
3094: ap_invoices_all api,
3095: ap_invoice_payments_all apip
3096: WHERE apc.check_id = to_number(p_reference3)
3097: AND api.invoice_id = to_number(p_reference2)