[Home] [Help]
18: user_access VARCHAR2(1) ;
19: CURSOR customer_assigned_cur(p_customer_id IN VARCHAR2, p_person_party_id IN VARCHAR2) IS
20: SELECT 'Y'
21: INTO user_access
22: FROM dual
23: WHERE p_customer_id IN (SELECT cust_account_id
24: FROM ar_customers_assigned_v
25: WHERE party_id = p_person_party_id);
26: CURSOR customer_site_assigned_cur(p_person_party_id IN VARCHAR2, p_customer_site_use_id IN VARCHAR2) IS
598: l_profile_default_currrency := FND_PROFILE.value('OIR_DEFAULT_CURRENCY_CODE');
599:
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
635: AND AUAS.session_id=p_session_id
636: AND ROWNUM = 1;
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
722: BEGIN
723:
724: SELECT 'Y'
725: INTO user_access
726: FROM dual
727: WHERE EXISTS (SELECT 'Y'
728: FROM ar_sites_assigned_v a,HZ_CUST_SITE_USES b
729: WHERE a.cust_acct_site_id = b.cust_acct_site_id
730: AND b.SITE_USE_CODE = 'BILL_TO'
768: BEGIN
769:
770: SELECT 'Y'
771: INTO user_access
772: FROM dual
773: WHERE p_customer_id IN (
774: select hca.cust_account_id
775: from hz_relationships hr,
776: hz_parties hp1,