DBA Data[Home] [Help]

APPS.AR_MO_GLOBAL_CACHE dependencies on GL_SETS_OF_BOOKS

Line 289: Check row exists in gl sets of books

285: APP_EXCEPTION.raise_exception;
286: RAISE;
287: end;
288: /* ---------------------------------------------
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,

Line 294: gl_sets_of_books sob

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

Line 313: gl_sets_of_books sob,

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