[Home] [Help]
2331: SELECT v.vendor_id vendor_id,
2332: v.vendor_type_lookup_code vendor_type,
2333: fvv.eliminations_id
2334: INTO l_vendor_id, l_vendor_type, l_eliminations_id
2335: FROM ap_invoices_all i,
2336: po_vendors v,
2337: fv_facts_vendors_v fvv
2338: WHERE i.invoice_id = to_number(l_reference_2)
2339: AND i.vendor_id = v.vendor_id
3205: SELECT inv.invoice_num,
3206: inv.invoice_date,
3207: inv.creation_date,
3208: inv.created_by
3209: FROM ap_invoices_all inv
3210: WHERE inv.invoice_id = to_number(p_reference2);
3211: CURSOR Pay_Pay IS
3212: SELECT DISTINCT api.invoice_num,
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)
3222: AND apc.check_id = apip.check_id
3295: CURSOR Pay_Pay_Void_Values IS
3296: SELECT api.invoice_num, apip.creation_date,
3297: apip.created_by
3298: FROM ap_invoice_payments_all apip,
3299: ap_invoices_all api
3300: WHERE api.invoice_id = NVL(p_reference2, 0)
3301: AND api.invoice_id = apip.invoice_id
3302: AND apip.check_id = NVL(p_reference3,0)
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)
3312: AND apc.check_id = apip.check_id
3758: --Need to get invoice number of the treasury confirmation
3759: --Using reference4 as invoice id
3760: SELECT invoice_num
3761: INTO l_document_num
3762: FROM ap_invoices_all
3763: WHERE invoice_id = p_reference4;
3764:
3765: ELSIF p_je_category_name = 'Treasury Confirmation'
3766: AND upper(p_name) like '%VOID%' THEN