APPS.AR_MO_CACHE_UTILS dependencies on AR_SYSTEM_PARAMETERS

Line 58: FROM ar_system_parameters sp

54:
55: /* Bug 5051539 */
56: cursor c_exception(c_org_id IN NUMBER) is
57: SELECT *
58: FROM ar_system_parameters sp
59: WHERE sp.org_id = nvl(c_org_id , sp.org_id);
60:
61: BEGIN
62: IF PG_DEBUG in ('Y', 'C') THEN

Line 406: ar_system_parameters sp,

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
408: where sp.set_of_books_id = sob.set_of_books_id
409: and sob.currency_code = fc.currency_code
410: and nvl(sp.org_id,-99) = nvl(rs.org_id,-99)

Line 740: ar_system_parameters sp,

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
742: where sp.set_of_books_id = sob.set_of_books_id
743: and sob.currency_code = fc.currency_code
744: and nvl(sp.org_id,-99) = nvl(rs.org_id,-99)

Line 772: from ar_system_parameters,

768: Check row exists in gl sets of books
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

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: