[Home] [Help]
2915: SELECT v.vendor_id vendor_id,
2916: NVL(v.global_attribute4,'N') vendor_type,
2917: SUBSTR(v.global_attribute5,1,3)
2918: INTO l_vendor_id, l_vendor_type, l_eliminations_id
2919: FROM ap_invoices_all i,
2920: po_vendors v
2921: WHERE i.invoice_id = to_number(l_reference_2)
2922: AND i.vendor_id = v.vendor_id;
2923:
3362: SELECT inv.invoice_num,
3363: inv.invoice_date,
3364: inv.creation_date,
3365: inv.created_by
3366: FROM ap_invoices_all inv
3367: WHERE inv.invoice_id = to_number(p_reference2);
3368:
3369: CURSOR Pay_Pay IS
3370: SELECT DISTINCT api.invoice_num,
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)
3380: AND apc.check_id = apip.check_id
3452: CURSOR Pay_Pay_Void_Values IS
3453: SELECT api.invoice_num, apip.creation_date,
3454: apip.created_by
3455: FROM ap_invoice_payments_all apip,
3456: ap_invoices_all api
3457: WHERE api.invoice_id = NVL(p_reference2, 0)
3458: AND api.invoice_id = apip.invoice_id
3459: AND apip.check_id = NVL(p_reference3,0)
3460: AND apip.invoice_payment_id = p_reference9;
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)
3470: AND apc.check_id = apip.check_id
3874: --Need to get invoice number of the treasury confirmation
3875: --Using reference4 as invoice id
3876: SELECT invoice_num
3877: INTO l_document_num
3878: FROM ap_invoices_all
3879: WHERE invoice_id = p_reference4;
3880:
3881: ELSIF p_je_category_name = 'Treasury Confirmation' AND
3882: upper(p_name) like '%VOID%' THEN