APPS.JL_CO_AP_WITHHOLDING_PKG dependencies on PO_VENDORS

Line 338: l_nit po_vendors.segment1%TYPE;

334: l_current_vendor_id Number;
335: l_current_awt Number;
336: l_initial_awt Number;
337: l_tax_base_amt Number;
338: l_nit po_vendors.segment1%TYPE;
339: l_user_defd_formula_exists Boolean := FALSE;
340: l_gl_period_name ap_invoice_distributions.period_name%TYPE;
341: l_base_currency_code Varchar2(15);
342: debug_info Varchar2(100);

Line 355: po_vendors pove

351: distinct nvl(substr(apid.global_attribute2,1,30),pove.segment1) nit
352: FROM
353: ap_invoices apin,
354: ap_invoice_distributions apid,
355: po_vendors pove
356: WHERE
357: apid.invoice_id = apin.invoice_id
358: AND pove.vendor_id = apin.vendor_id
359: AND apin.invoice_id = Inv_Id;

Line 382: po_vendors pove,

378: ap_invoice_distributions apid,
379: jl_zz_ap_supp_awt_types jlst,
380: jl_zz_ap_sup_awt_cd jlsc,
381: jl_zz_ap_awt_types jlat,
382: po_vendors pove,
383: po_vendors pove2
384: WHERE
385: apid.invoice_id = jlwh.invoice_id
386: AND apid.invoice_distribution_id = jlwh.invoice_distribution_id

Line 383: po_vendors pove2

379: jl_zz_ap_supp_awt_types jlst,
380: jl_zz_ap_sup_awt_cd jlsc,
381: jl_zz_ap_awt_types jlat,
382: po_vendors pove,
383: po_vendors pove2
384: WHERE
385: apid.invoice_id = jlwh.invoice_id
386: AND apid.invoice_distribution_id = jlwh.invoice_distribution_id
387: AND apin.invoice_id = apid.invoice_id

Line 796: po_vendors pove

792: ap_invoice_distributions apid,
793: jl_zz_ap_supp_awt_types jlst,
794: jl_zz_ap_sup_awt_cd jlsc,
795: jl_zz_ap_awt_types jlat,
796: po_vendors pove
797: WHERE
798: apid.invoice_id = jlwh.invoice_id
799: AND apid.invoice_distribution_id = jlwh.invoice_distribution_id
800: AND apin.invoice_id = apid.invoice_id