APPS.AR_MO_CACHE_UTILS dependencies on FND_CURRENCIES

Line 398: fnd_currencies fc,

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
402: where sp.set_of_books_id = sob.set_of_books_id

Line 726: fnd_currencies fc,

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
730: where sp.set_of_books_id = sob.set_of_books_id

Line 773: Check row exists in fnd_currencies

769: APP_EXCEPTION.raise_exception;
770: RAISE;
771: end;
772: /* ---------------------------------------------
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

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:

Line 786: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_FND_CURRENCIES');

782: exception when no_data_found then
783: IF PG_DEBUG in ('Y', 'C') THEN
784: arp_util.debug('EXCEPTION: NO_DATA_FOUND IN CURRENCIES - ar_mo_cache_utils.retrieve_globals' );
785: END IF;
786: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_FND_CURRENCIES');
787: APP_EXCEPTION.raise_exception;
788: RAISE; --end of WHEN NO DATA FOUND
789: end;
790: