APPS.JL_CO_AP_WITHHOLDING_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 144: l_create_dists ap_system_parameters.create_awt_dists_type%TYPE;

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);
147: debug_info Varchar2(100);
148: l_AWT_DATE DATE; -- bug: 8770258

Line 145: l_create_invoices ap_system_parameters.create_awt_invoices_type%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);
147: debug_info Varchar2(100);
148: l_AWT_DATE DATE; -- bug: 8770258
149: l_gl_awt_date date := NULL; --bug 9593393

Line 220: ap_system_parameters;

216: INTO
217: l_create_dists,
218: l_create_invoices
219: FROM
220: ap_system_parameters;
221:
222: ------------------------------------------------------------------------
223: -- Checks whether the withholding taxes are calculated at invoice
224: -- approval time

Line 248: ap_system_parameters ASP

244: BEGIN
245: select GPS.period_name
246: into l_gl_period_name
247: from gl_period_statuses GPS,
248: ap_system_parameters ASP
249: where GPS.application_id = 200
250: and GPS.set_of_books_id = ASP.set_of_books_id
251: and trunc(l_AWT_Date) between
252: trunc(GPS.start_date) and trunc(GPS.end_date)