APPS.ASO_ORDER_INT dependencies on HZ_CUST_ACCOUNT_ROLES

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