APPS.ARI_UTILITIES dependencies on FND_CURRENCIES_VL

Line 604: FND_CURRENCIES_VL CUR, HZ_CUSTOMER_PROFILES CPF, ar_irec_user_acct_sites_all AUAS

600: IF(p_customer_id IS NULL) THEN
601:
602: select count(*) into l_currency_exist from dual where l_profile_default_currrency in
603: ( SELECT unique ( CUR.CURRENCY_CODE ) FROM HZ_CUST_PROFILE_AMTS CPA,
604: FND_CURRENCIES_VL CUR, HZ_CUSTOMER_PROFILES CPF, ar_irec_user_acct_sites_all AUAS
605: WHERE CPA.CURRENCY_CODE = CUR.CURRENCY_CODE
606: AND CPF.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID
607: AND CPF.CUST_ACCOUNT_ID =AUAS.CUSTOMER_ID
608: AND (

Line 622: FND_CURRENCIES_VL CUR,

618:
619: SELECT unique ( CUR.CURRENCY_CODE )
620: INTO l_default_currency
621: FROM HZ_CUST_PROFILE_AMTS CPA,
622: FND_CURRENCIES_VL CUR,
623: HZ_CUSTOMER_PROFILES CPF,
624: ar_irec_user_acct_sites_all AUAS
625: WHERE CPA.CURRENCY_CODE = CUR.CURRENCY_CODE
626: AND CPF.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID

Line 641: FND_CURRENCIES_VL CUR, HZ_CUSTOMER_PROFILES CPF, ar_irec_user_acct_sites_all AUAS

637: ELSE
638:
639: select count(*) into l_currency_exist from dual where l_profile_default_currrency in
640: ( SELECT unique ( CUR.CURRENCY_CODE ) FROM HZ_CUST_PROFILE_AMTS CPA,
641: FND_CURRENCIES_VL CUR, HZ_CUSTOMER_PROFILES CPF, ar_irec_user_acct_sites_all AUAS
642: WHERE CPA.CURRENCY_CODE = CUR.CURRENCY_CODE
643: AND CPF.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID
644: AND CPF.CUST_ACCOUNT_ID = p_customer_id
645: AND (

Line 660: FND_CURRENCIES_VL CUR,

656:
657: SELECT unique ( CUR.CURRENCY_CODE )
658: INTO l_default_currency
659: FROM HZ_CUST_PROFILE_AMTS CPA,
660: FND_CURRENCIES_VL CUR,
661: HZ_CUSTOMER_PROFILES CPF,
662: ar_irec_user_acct_sites_all AUAS
663: WHERE
664: CPA.CURRENCY_CODE = CUR.CURRENCY_CODE AND