APPS.AP_APXINRIR_XMLP_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 126: FROM AP_SYSTEM_PARAMETERS;

122:
123:
124: SELECT sort_by_alternate_field
125: INTO SORT_BY_ALTERNATE
126: FROM AP_SYSTEM_PARAMETERS;
127:
128:
129:
130: EXCEPTION

Line 165: SELECT ap_system_parameters.batch_control_flag

161: l_userid number(14);
162: l_cash_basis_flag VARCHAR2(1);
163: BEGIN
164: BEGIN
165: SELECT ap_system_parameters.batch_control_flag
166: INTO l_batch_flag
167: FROM ap_system_parameters;
168: C_BATCH_FLAG := l_batch_flag;
169: EXCEPTION

Line 167: FROM ap_system_parameters;

163: BEGIN
164: BEGIN
165: SELECT ap_system_parameters.batch_control_flag
166: INTO l_batch_flag
167: FROM ap_system_parameters;
168: C_BATCH_FLAG := l_batch_flag;
169: EXCEPTION
170: WHEN NO_DATA_FOUND THEN NULL;
171: END;

Line 177: ap_system_parameters asp

173: BEGIN
174: SELECT nvl(sla_ledger_cash_basis_flag, 'N')
175: INTO l_cash_basis_flag
176: FROM gl_sets_of_books sob,
177: ap_system_parameters asp
178: WHERE asp.set_of_books_id = sob.set_of_books_id;
179: EXCEPTION
180: WHEN NO_DATA_FOUND THEN
181: l_cash_basis_flag :='N';

Line 231: FROM ap_system_parameters p,

227: c.minimum_accountable_unit
228: INTO l_base_curr,
229: l_prec,
230: l_min_au
231: FROM ap_system_parameters p,
232: fnd_currencies_vl c
233: WHERE p.base_currency_code = c.currency_code;
234:
235: c_base_currency_code := l_base_curr;

Line 256: from ap_system_parameters;

252:
253:
254: select set_of_books_id
255: into l_sob_id
256: from ap_system_parameters;
257:
258: p_sob_id := l_sob_id;
259: SELECT substr(name,1,30),
260: chart_of_accounts_id