APPS.ARI_UTILITIES dependencies on AR_SITES_ASSIGNED_V

Line 28: FROM ar_sites_assigned_v a,HZ_CUST_SITE_USES b

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
27: SELECT 'Y'
28: FROM ar_sites_assigned_v a,HZ_CUST_SITE_USES b
29: where a.cust_acct_site_id = b.cust_acct_site_id
30: and b.SITE_USE_CODE = 'BILL_TO'
31: AND party_id = p_person_party_id and site_use_id = p_customer_site_use_id;
32:

Line 770: FROM ar_sites_assigned_v a,HZ_CUST_SITE_USES b

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'
773: AND party_id = p_person_party_id
774: AND site_use_id = p_customer_site_use_id );

Line 2048: select count(*) into l_site_access_count from ar_sites_assigned_v acct_sites_count

2044: IF l_account_access_count > 0 THEN
2045: RETURN 0;
2046: END IF;
2047:
2048: select count(*) into l_site_access_count from ar_sites_assigned_v acct_sites_count
2049: where acct_sites_count.party_id=p_party_id
2050: and acct_sites_count.cust_account_id=p_customer_id
2051: and INSTR(ARI_UTILITIES.GET_SITE_USE_CODE(acct_sites_count.CUST_ACCT_SITE_ID), 'BILL_TO')>0;
2052:

Line 2057: select ARI_UTILITIES.get_bill_to_site_use_id(CUST_ACCT_SITE_ID) from ar_sites_assigned_v where

2053: select count(*) into l_flag from(
2054: select trx_number,CUSTOMER_SITE_USE_ID from ar_payment_schedules where trx_number=p_trx_number
2055: and CUSTOMER_SITE_USE_ID in
2056: (
2057: select ARI_UTILITIES.get_bill_to_site_use_id(CUST_ACCT_SITE_ID) from ar_sites_assigned_v where
2058: party_id=p_party_id
2059: and cust_account_id=p_customer_id
2060: )
2061: );