APPS.AR_MO_CACHE_UTILS dependencies on GL_SETS_OF_BOOKS

Line 397: gl_sets_of_books sob,

393: p_globals.matched_claim_excl_cm_flag_t,
394: p_globals.min_wrtoff_amount_t,
395: p_globals.min_refund_amount_t
396: from
397: gl_sets_of_books sob,
398: fnd_currencies fc,
399: jtf_rs_salesreps rs,
400: ar_system_parameters sp,
401: zx_product_options zxpo

Line 725: gl_sets_of_books sob,

721: p_globals.matched_claim_excl_cm_flag_t,
722: p_globals.min_wrtoff_amount_t,
723: p_globals.min_refund_amount_t
724: from
725: gl_sets_of_books sob,
726: fnd_currencies fc,
727: jtf_rs_salesreps rs,
728: ar_system_parameters sp,
729: zx_product_options zxpo

Line 756: Check row exists in gl sets of books

752:
753: l_exp_flag := 'Y';
754:
755: /* ---------------------------------------------
756: Check row exists in gl sets of books
757: ---------------------------------------------- */
758: begin
759: SELECT 'x' into l_sob_test
760: from ar_system_parameters,

Line 761: gl_sets_of_books sob

757: ---------------------------------------------- */
758: begin
759: SELECT 'x' into l_sob_test
760: from ar_system_parameters,
761: gl_sets_of_books sob
762: where sob.set_of_books_id = REC.set_of_books_id
763: and org_id = REC.org_id;
764: exception when no_data_found then
765: IF PG_DEBUG in ('Y', 'C') THEN

Line 777: FROM ar_system_parameters sp, gl_sets_of_books sob, fnd_currencies c

773: Check row exists in fnd_currencies
774: ---------------------------------------------- */
775: begin
776: SELECT 'x' into l_sob_test
777: FROM ar_system_parameters sp, gl_sets_of_books sob, fnd_currencies c
778: WHERE sob.set_of_books_id = sp.set_of_books_id
779: and sp.org_id = REC.org_id
780: and sob.currency_code = c.currency_code;
781: