APPS.ASO_ORDER_INT dependencies on HZ_CUST_ACCOUNT_ROLES

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