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 400: ar_system_parameters sp,

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

Line 728: ar_system_parameters sp,

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

Line 760: from ar_system_parameters,

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

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: