APPS.ASO_ORDER_INT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 3112: hz_cust_site_uses_all a, hz_cust_acct_sites_all b

3108: and b.party_id = a.party_id;
3109: CURSOR site_use_cur IS
3110: select a.site_use_id
3111: from
3112: hz_cust_site_uses_all a, hz_cust_acct_sites_all b
3113: where
3114: a.status = 'A'
3115: and b.cust_account_id = p_cust_account_id
3116: and b.party_site_id = p_party_site_id

Line 3175: hz_cust_account_roles a, hz_role_responsibility b, hz_cust_acct_sites_all c

3171: and (sysdate between nvl(b.start_date, sysdate) and nvl(b.end_date, sysdate));
3172: CURSOR cust_role IS
3173: select a.cust_account_role_id
3174: from
3175: hz_cust_account_roles a, hz_role_responsibility b, hz_cust_acct_sites_all c
3176: where
3177: a.role_type = 'CONTACT'
3178: and a.party_id = p_party_id
3179: and a.cust_account_id = p_cust_account_id