DBA Data[Home] [Help]

APPS.AR_MO_GLOBAL_CACHE dependencies on GL_SETS_OF_BOOKS

Line 286: Check row exists in gl sets of books

282: APP_EXCEPTION.raise_exception;
283: RAISE;
284: end;
285: /* ---------------------------------------------
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,

Line 291: gl_sets_of_books sob

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
295: when no_data_found then

Line 310: gl_sets_of_books sob,

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
314: and sob.currency_code = c.currency_code;