APPS.ARI_UTILITIES dependencies on HZ_CUST_PROFILE_AMTS

Line 605: (( SELECT /*+ leading(auas) use_nl(auas cpf) */ unique ( CUR.CURRENCY_CODE ) FROM HZ_CUST_PROFILE_AMTS CPA,

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

Line 630: FROM HZ_CUST_PROFILE_AMTS CPA,

626: end if;
627:
628: SELECT /*+ leading(auas) use_nl(auas cpf) */ unique ( CUR.CURRENCY_CODE )
629: INTO l_default_currency
630: FROM HZ_CUST_PROFILE_AMTS CPA,
631: FND_CURRENCIES_VL CUR,
632: HZ_CUSTOMER_PROFILES CPF,
633: ar_irec_user_acct_sites_all AUAS
634: WHERE CPA.CURRENCY_CODE = CUR.CURRENCY_CODE

Line 662: (( SELECT /*+ leading(auas) use_nl(auas cpf) */ unique ( CUR.CURRENCY_CODE ) FROM HZ_CUST_PROFILE_AMTS CPA,

658:
659: ELSE
660:
661: select count(*) into l_currency_exist from dual where l_profile_default_currrency in
662: (( SELECT /*+ leading(auas) use_nl(auas cpf) */ unique ( CUR.CURRENCY_CODE ) FROM HZ_CUST_PROFILE_AMTS CPA,
663: FND_CURRENCIES_VL CUR, HZ_CUSTOMER_PROFILES CPF, ar_irec_user_acct_sites_all AUAS
664: WHERE CPA.CURRENCY_CODE = CUR.CURRENCY_CODE
665: AND CPF.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID
666: AND CPF.CUST_ACCOUNT_ID = p_customer_id

Line 688: FROM HZ_CUST_PROFILE_AMTS CPA,

684: end if;
685:
686: SELECT /*+ leading(auas) use_nl(auas cpf) */ unique ( CUR.CURRENCY_CODE )
687: INTO l_default_currency
688: FROM HZ_CUST_PROFILE_AMTS CPA,
689: FND_CURRENCIES_VL CUR,
690: HZ_CUSTOMER_PROFILES CPF,
691: ar_irec_user_acct_sites_all AUAS
692: WHERE