APPS.JL_CO_AP_WITHHOLDING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 340: l_gl_period_name ap_invoice_distributions.period_name%TYPE;

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);
343: current_calling_sequence Varchar2(2000);
344:

Line 354: ap_invoice_distributions apid,

350: SELECT
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

Line 378: ap_invoice_distributions apid,

374: nvl(apid.base_amount, apid.amount) line_amount
375: FROM
376: jl_zz_ap_inv_dis_wh jlwh,
377: ap_invoices apin,
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,

Line 792: ap_invoice_distributions apid,

788: jlat.user_defined_formula_flag user_defined_formula_flag
789: FROM
790: jl_zz_ap_inv_dis_wh jlwh,
791: ap_invoices apin,
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