APPS.ARI_UTILITIES dependencies on AR_CUSTOMERS_ASSIGNED_V

Line 24: FROM ar_customers_assigned_v

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
27: SELECT 'Y'
28: FROM ar_sites_assigned_v a,HZ_CUST_SITE_USES b

Line 35: FROM ar_customers_assigned_v Custs_assigned,

31: AND party_id = p_person_party_id and site_use_id = p_customer_site_use_id;
32:
33: CURSOR customer_acc_site_cur(p_person_party_id IN VARCHAR2, p_customer_site_use_id IN VARCHAR2) IS
34: SELECT 'Y'
35: FROM ar_customers_assigned_v Custs_assigned,
36: hz_cust_acct_sites Site,HZ_CUST_SITE_USES site_uses
37: WHERE Custs_assigned.party_id = p_person_party_id
38: AND Site.cust_account_id =
39: Custs_assigned.cust_account_id

Line 2040: select count(*) into l_account_access_count from ar_customers_assigned_v hzca where hzca.cust_account_id = p_customer_id

2036: l_flag NUMBER := NULL;
2037:
2038: BEGIN
2039:
2040: select count(*) into l_account_access_count from ar_customers_assigned_v hzca where hzca.cust_account_id = p_customer_id
2041: and hzca.party_id=p_party_id;
2042:
2043:
2044: IF l_account_access_count > 0 THEN