APPS.ARI_UTILITIES dependencies on DUAL

Line 22: FROM dual

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

Line 604: select count(*) into l_currency_exist from dual where l_profile_default_currrency in

600: l_profile_default_currrency := FND_PROFILE.value('OIR_DEFAULT_CURRENCY_CODE');
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

Line 661: select count(*) into l_currency_exist from dual where l_profile_default_currrency in

657: end if;
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

Line 768: FROM dual

764: BEGIN
765:
766: SELECT 'Y'
767: INTO user_access
768: FROM dual
769: WHERE EXISTS (SELECT 'Y'
770: FROM ar_sites_assigned_v a,HZ_CUST_SITE_USES b
771: WHERE a.cust_acct_site_id = b.cust_acct_site_id
772: AND b.SITE_USE_CODE = 'BILL_TO'

Line 814: FROM dual

810: BEGIN
811:
812: SELECT 'Y'
813: INTO user_access
814: FROM dual
815: WHERE p_customer_id IN (
816: select hca.cust_account_id
817: from hz_relationships hr,
818: hz_parties hp1,

Line 2007: FROM dual;

2003: END IF;
2004:
2005: SELECT lengthb(p_num_to_strip)
2006: INTO len_strip_num
2007: FROM dual;
2008:
2009: FOR i in 1..len_strip_num LOOP
2010: SELECT substrb(p_num_to_strip,i,1)
2011: INTO l_strip_num_char(i)

Line 2012: FROM dual;

2008:
2009: FOR i in 1..len_strip_num LOOP
2010: SELECT substrb(p_num_to_strip,i,1)
2011: INTO l_strip_num_char(i)
2012: FROM dual;
2013:
2014: IF ( (l_strip_num_char(i) >= '0') and
2015: (l_strip_num_char(i) <= '9')
2016: )