DBA Data[Home] [Help]

APPS.AR_MO_CACHE_UTILS dependencies on GL_SETS_OF_BOOKS

Line 403: gl_sets_of_books sob,

399: p_globals.min_refund_amount_t,
400: p_globals.create_detailed_dist_flag_t,
401: p_globals.default_rct_mthd_for_lc_inv_t
402: from
403: gl_sets_of_books sob,
404: fnd_currencies fc,
405: jtf_rs_salesreps rs,
406: ar_system_parameters sp,
407: zx_product_options zxpo

Line 737: gl_sets_of_books sob,

733: p_globals.min_refund_amount_t,
734: p_globals.create_detailed_dist_flag_t,
735: p_globals.default_rct_mthd_for_lc_inv_t
736: from
737: gl_sets_of_books sob,
738: fnd_currencies fc,
739: jtf_rs_salesreps rs,
740: ar_system_parameters sp,
741: zx_product_options zxpo

Line 768: Check row exists in gl sets of books

764:
765: l_exp_flag := 'Y';
766:
767: /* ---------------------------------------------
768: Check row exists in gl sets of books
769: ---------------------------------------------- */
770: begin
771: SELECT 'x' into l_sob_test
772: from ar_system_parameters,

Line 773: gl_sets_of_books sob

769: ---------------------------------------------- */
770: begin
771: SELECT 'x' into l_sob_test
772: from ar_system_parameters,
773: gl_sets_of_books sob
774: where sob.set_of_books_id = REC.set_of_books_id
775: and org_id = REC.org_id;
776: exception when no_data_found then
777: IF PG_DEBUG in ('Y', 'C') THEN

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

785: Check row exists in fnd_currencies
786: ---------------------------------------------- */
787: begin
788: SELECT 'x' into l_sob_test
789: FROM ar_system_parameters sp, gl_sets_of_books sob, fnd_currencies c
790: WHERE sob.set_of_books_id = sp.set_of_books_id
791: and sp.org_id = REC.org_id
792: and sob.currency_code = c.currency_code;
793: