APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on AP_INVOICES_ALL

Line 2229: From AP_Invoices_all inv

2225:
2226: Cursor Pay_Pur is
2227: Select inv.Invoice_Num
2228: ,inv.INvoice_Date,inv.created_by,inv.creation_date
2229: From AP_Invoices_all inv
2230: Where to_char(inv.Invoice_Id) = P_Reference2;
2231:
2232: Cursor Pay_Pay is
2233: Select Distinct api.invoice_num,

Line 2236: ap_invoices_all api,

2232: Cursor Pay_Pay is
2233: Select Distinct api.invoice_num,
2234: apc.check_date,api.created_by,api.creation_date
2235: From ap_checks_all apc,
2236: ap_invoices_all api,
2237: ap_invoice_payments_all apip
2238: where to_char(apc.check_id) = p_reference3
2239: and to_char(api.invoice_id) = p_reference2
2240: and apc.check_id = apip.check_id

Line 2324: ap_invoices_all api

2320:
2321: Cursor Pay_Pay_Void_Values is
2322: SELECT api.invoice_num, apip.creation_date, apip.created_by
2323: FROM ap_invoice_payments_all apip,
2324: ap_invoices_all api
2325: WHERE api.invoice_id = NVL(p_reference2, 0)
2326: AND api.invoice_id = apip.invoice_id
2327: AND apip.check_id = NVL(p_reference3,0)
2328: AND apip.invoice_payment_id = p_reference9;

Line 2333: ap_invoices_all api,

2329:
2330: Cursor Pay_Pay_Non_Void is
2331: SELECT api.invoice_num, apc.creation_date, apc.created_by
2332: FROM ap_checks_all apc,
2333: ap_invoices_all api,
2334: ap_invoice_payments_all apip
2335: WHERE to_char(apc.check_id) = p_reference3
2336: AND to_char(api.invoice_id) = p_reference2
2337: AND apc.check_id = apip.check_id