APPS.JL_CO_AP_WITHHOLDING_PKG dependencies on AP_INVOICES

Line 140: l_awt_flag ap_invoices.awt_flag%TYPE;

136: IS
137: ------------------------
138: -- Variables Definition
139: ------------------------
140: l_awt_flag ap_invoices.awt_flag%TYPE;
141: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;
142: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
143: l_AWT_success Varchar2(2000) := 'SUCCESS';
144: l_create_dists ap_system_parameters.create_awt_dists_type%TYPE;

Line 141: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;

137: ------------------------
138: -- Variables Definition
139: ------------------------
140: l_awt_flag ap_invoices.awt_flag%TYPE;
141: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;
142: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
143: l_AWT_success Varchar2(2000) := 'SUCCESS';
144: l_create_dists ap_system_parameters.create_awt_dists_type%TYPE;
145: l_create_invoices ap_system_parameters.create_awt_invoices_type%TYPE;

Line 142: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;

138: -- Variables Definition
139: ------------------------
140: l_awt_flag ap_invoices.awt_flag%TYPE;
141: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;
142: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
143: l_AWT_success Varchar2(2000) := 'SUCCESS';
144: l_create_dists ap_system_parameters.create_awt_dists_type%TYPE;
145: l_create_invoices ap_system_parameters.create_awt_invoices_type%TYPE;
146: current_calling_sequence Varchar2(2000);

Line 196: ap_invoices

192: l_inv_curr_code,
193: l_invoice_type_lookup_code,
194: l_AWT_DATE -- bug: 8770258
195: FROM
196: ap_invoices
197: WHERE
198: invoice_id = P_Invoice_Id;
199:
200: ---------------------------

Line 457: ap_invoices apin,

453: IS
454: SELECT
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

Line 481: ap_invoices apin,

477: nvl(apin.base_amount, apin.invoice_amount) invoice_amount,
478: nvl(apid.base_amount, apid.amount) line_amount
479: FROM
480: jl_zz_ap_inv_dis_wh jlwh,
481: ap_invoices apin,
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,

Line 895: ap_invoices apin,

891: SELECT
892: jlat.user_defined_formula_flag user_defined_formula_flag
893: FROM
894: jl_zz_ap_inv_dis_wh jlwh,
895: ap_invoices apin,
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,