APPS.AR_MO_GLOBAL_CACHE dependencies on AR_SYSTEM_PARAMETERS

Line 273: from ar_system_parameters

269: Check row exists in ar_system_parameter
270: ---------------------------------------------- */
271: begin
272: SELECT 'x' into l_exp_flag
273: from ar_system_parameters
274: where org_id = p_org_id;
275: exception
276: WHEN NO_DATA_FOUND THEN
277: IF PG_DEBUG in ('Y', 'C') THEN

Line 290: from ar_system_parameters sp,

286: Check row exists in gl sets of books
287: ---------------------------------------------- */
288: begin
289: SELECT 'x' into l_exp_flag
290: from ar_system_parameters sp,
291: gl_sets_of_books sob
292: where sob.set_of_books_id = sp.set_of_books_id
293: and sp.org_id = p_org_id;
294: exception

Line 309: FROM ar_system_parameters sp,

305: Check row exists in fnd_currencies
306: ---------------------------------------------- */
307: begin
308: SELECT 'x' into l_exp_flag
309: FROM ar_system_parameters sp,
310: gl_sets_of_books sob,
311: fnd_currencies c
312: WHERE sob.set_of_books_id = sp.set_of_books_id
313: and sp.org_id = p_org_id