DBA Data[Home] [Help]

APPS.HZ_ACT_UTIL_PUB dependencies on HZ_ROLE_RESPONSIBILITY

Line 134: hz_role_responsibility role_type,

130: -- Account CPUI : Modify to get roles for INACTIVE contact also
131: cursor c_get_act_contact_roles (l_cust_account_role_id IN NUMBER) is
132: select al.MEANING
133: from --hz_cust_account_roles roles,
134: hz_role_responsibility role_type,
135: ar_lookups al
136: where role_type.cust_account_role_id = l_cust_account_role_id
137: -- and roles.cust_account_role_id = role_type.cust_account_role_id
138: and al.lookup_type = 'SITE_USE_CODE'