DBA Data[Home] [Help]

APPS.AR_MO_GLOBAL_CACHE dependencies on AR_SYSTEM_PARAMETERS

Line 276: from ar_system_parameters

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

Line 293: from ar_system_parameters sp,

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

Line 312: FROM ar_system_parameters sp,

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