APPS.JL_CO_AP_WITHHOLDING_PKG dependencies on AP_INVOICES

Line 123: l_awt_flag ap_invoices.awt_flag%TYPE;

119: IS
120: ------------------------
121: -- Variables Definition
122: ------------------------
123: l_awt_flag ap_invoices.awt_flag%TYPE;
124: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;
125: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
126: l_AWT_success Varchar2(2000) := 'SUCCESS';
127: l_create_dists ap_system_parameters.create_awt_dists_type%TYPE;

Line 124: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;

120: ------------------------
121: -- Variables Definition
122: ------------------------
123: l_awt_flag ap_invoices.awt_flag%TYPE;
124: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;
125: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
126: l_AWT_success Varchar2(2000) := 'SUCCESS';
127: l_create_dists ap_system_parameters.create_awt_dists_type%TYPE;
128: l_create_invoices ap_system_parameters.create_awt_invoices_type%TYPE;

Line 125: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;

121: -- Variables Definition
122: ------------------------
123: l_awt_flag ap_invoices.awt_flag%TYPE;
124: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;
125: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
126: l_AWT_success Varchar2(2000) := 'SUCCESS';
127: l_create_dists ap_system_parameters.create_awt_dists_type%TYPE;
128: l_create_invoices ap_system_parameters.create_awt_invoices_type%TYPE;
129: current_calling_sequence Varchar2(2000);

Line 163: ap_invoices

159: l_awt_flag,
160: l_inv_curr_code,
161: l_invoice_type_lookup_code
162: FROM
163: ap_invoices
164: WHERE
165: invoice_id = P_Invoice_Id;
166:
167: ---------------------------

Line 353: ap_invoices apin,

349: IS
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

Line 377: ap_invoices apin,

373: nvl(apin.base_amount, apin.invoice_amount) invoice_amount,
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,

Line 791: ap_invoices apin,

787: SELECT
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,