APPS.JL_CO_AP_WITHHOLDING_PKG dependencies on PO_VENDORS

Line 442: l_nit po_vendors.segment1%TYPE;

438: l_current_vendor_id Number;
439: l_current_awt Number;
440: l_initial_awt Number;
441: l_tax_base_amt Number;
442: l_nit po_vendors.segment1%TYPE;
443: l_user_defd_formula_exists Boolean := FALSE;
444: --bug 9593393 l_gl_period_name ap_invoice_distributions.period_name%TYPE;
445: l_base_currency_code Varchar2(15);
446: debug_info Varchar2(100);

Line 459: po_vendors pove

455: distinct nvl(substr(apid.global_attribute2,1,30),pove.segment1) nit
456: FROM
457: ap_invoices apin,
458: ap_invoice_distributions apid,
459: po_vendors pove
460: WHERE
461: apid.invoice_id = apin.invoice_id
462: AND pove.vendor_id = apin.vendor_id
463: AND apin.invoice_id = Inv_Id;

Line 486: po_vendors pove,

482: ap_invoice_distributions apid,
483: jl_zz_ap_supp_awt_types jlst,
484: jl_zz_ap_sup_awt_cd jlsc,
485: jl_zz_ap_awt_types jlat,
486: po_vendors pove,
487: po_vendors pove2
488: WHERE
489: apid.invoice_id = jlwh.invoice_id
490: AND apid.invoice_distribution_id = jlwh.invoice_distribution_id

Line 487: po_vendors pove2

483: jl_zz_ap_supp_awt_types jlst,
484: jl_zz_ap_sup_awt_cd jlsc,
485: jl_zz_ap_awt_types jlat,
486: po_vendors pove,
487: po_vendors pove2
488: WHERE
489: apid.invoice_id = jlwh.invoice_id
490: AND apid.invoice_distribution_id = jlwh.invoice_distribution_id
491: AND apin.invoice_id = apid.invoice_id

Line 900: po_vendors pove

896: ap_invoice_distributions apid,
897: jl_zz_ap_supp_awt_types jlst,
898: jl_zz_ap_sup_awt_cd jlsc,
899: jl_zz_ap_awt_types jlat,
900: po_vendors pove
901: WHERE
902: apid.invoice_id = jlwh.invoice_id
903: AND apid.invoice_distribution_id = jlwh.invoice_distribution_id
904: AND apin.invoice_id = apid.invoice_id