APPS.ASO_ORDER_INT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 3278: hz_cust_site_uses_all a, hz_cust_acct_sites_all b

3274: and b.party_id = a.party_id;
3275: CURSOR site_use_cur IS
3276: select a.site_use_id
3277: from
3278: hz_cust_site_uses_all a, hz_cust_acct_sites_all b
3279: where
3280: a.status = 'A'
3281: and b.cust_account_id = p_cust_account_id
3282: and b.party_site_id = p_party_site_id

Line 3341: hz_cust_account_roles a, hz_role_responsibility b, hz_cust_acct_sites_all c

3337: and (sysdate between nvl(b.start_date, sysdate) and nvl(b.end_date, sysdate));
3338: CURSOR cust_role IS
3339: select a.cust_account_role_id
3340: from
3341: hz_cust_account_roles a, hz_role_responsibility b, hz_cust_acct_sites_all c
3342: where
3343: a.role_type = 'CONTACT'
3344: and a.party_id = p_party_id
3345: and a.cust_account_id = p_cust_account_id