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 728: FROM ar_sites_assigned_v a,HZ_CUST_SITE_USES b

724: SELECT 'Y'
725: INTO user_access
726: FROM dual
727: WHERE EXISTS (SELECT 'Y'
728: FROM ar_sites_assigned_v a,HZ_CUST_SITE_USES b
729: WHERE a.cust_acct_site_id = b.cust_acct_site_id
730: AND b.SITE_USE_CODE = 'BILL_TO'
731: AND party_id = p_person_party_id
732: AND site_use_id = p_customer_site_use_id );

Line 1520: hz_cust_site_uses

1516: CURSOR c01 (addr_id VARCHAR2) IS
1517: SELECT
1518: unique( LOCATION)
1519: FROM
1520: hz_cust_site_uses
1521: WHERE
1522: cust_acct_site_id = addr_id
1523: AND status = 'A' ;
1524: l_procedure_name VARCHAR2(50);

Line 1584: hz_cust_site_uses

1580: CURSOR c01 (addr_id VARCHAR2) IS
1581: SELECT
1582: SITE_USE_CODE, SITE_USE_ID
1583: FROM
1584: hz_cust_site_uses
1585: WHERE
1586: cust_acct_site_id = addr_id;
1587: --AND status = 'A' ;
1588: /*Bug 6503280: Commented out above condition on checking status='A'

Line 1726: from ar_payment_schedules_all aps,HZ_CUST_SITE_USES sites

1722: --------------------------------------------------------------------
1723:
1724: select aps.customer_id,sites.CUST_ACCT_SITE_ID,trx_number
1725: into l_customer_id,l_customer_acct_site_id,l_trx_number
1726: from ar_payment_schedules_all aps,HZ_CUST_SITE_USES sites
1727: where aps.customer_trx_id = l_customer_trx_id
1728: and aps.org_id = l_org_id
1729: and sites.site_use_id = aps.customer_site_use_id;
1730: