APPS.ARI_UTILITIES dependencies on HZ_CUST_SITE_USES

Line 11: G_BILL_TO_SITE_USE_ID HZ_CUST_SITE_USES.SITE_USE_ID%TYPE := 0;

7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ARI_UTILITIES';
8: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
9:
10: G_PRV_ADDRESS_ID HZ_CUST_ACCT_SITES.CUST_ACCT_SITE_ID%TYPE := 0;
11: G_BILL_TO_SITE_USE_ID HZ_CUST_SITE_USES.SITE_USE_ID%TYPE := 0;
12: G_PRV_SITE_USES VARCHAR2(2000);
13:
14:
15: FUNCTION check_external_user_access (p_person_party_id IN VARCHAR2,

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 36: hz_cust_acct_sites Site,HZ_CUST_SITE_USES site_uses

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
40: and Site.cust_acct_site_id =

Line 460: hz_cust_site_uses

456: CURSOR c01 (addr_id VARCHAR2) IS
457: SELECT
458: SITE_USE_CODE, SITE_USE_ID
459: FROM
460: hz_cust_site_uses
461: WHERE
462: cust_acct_site_id = addr_id;
463: --AND status = 'A' ;
464: /*Bug 6503280: Commented out above condition on checking status='A'

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 1582: hz_cust_site_uses

1578: CURSOR c01 (addr_id VARCHAR2) IS
1579: SELECT
1580: unique( LOCATION)
1581: FROM
1582: hz_cust_site_uses
1583: WHERE
1584: cust_acct_site_id = addr_id
1585: AND status = 'A' ;
1586: l_procedure_name VARCHAR2(50);

Line 1646: hz_cust_site_uses

1642: CURSOR c01 (addr_id VARCHAR2) IS
1643: SELECT
1644: SITE_USE_CODE, SITE_USE_ID
1645: FROM
1646: hz_cust_site_uses
1647: WHERE
1648: cust_acct_site_id = addr_id;
1649: --AND status = 'A' ;
1650: /*Bug 6503280: Commented out above condition on checking status='A'

Line 2126: from ar_payment_schedules_all aps,HZ_CUST_SITE_USES sites

2122: --------------------------------------------------------------------
2123:
2124: select aps.customer_id,sites.CUST_ACCT_SITE_ID,aps.trx_number
2125: into l_customer_id,l_customer_acct_site_id,l_trx_number
2126: from ar_payment_schedules_all aps,HZ_CUST_SITE_USES sites
2127: where aps.customer_trx_id = l_customer_trx_id
2128: and aps.org_id = l_org_id
2129: and sites.site_use_id = aps.customer_site_use_id;
2130: