APPS.ARI_UTILITIES dependencies on HZ_CUST_ACCT_SITES

Line 10: G_PRV_ADDRESS_ID HZ_CUST_ACCT_SITES.CUST_ACCT_SITE_ID%TYPE := 0;

6: +=======================================================================*/
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:

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 =