DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on JTF_RS_GROUP_MEMBERS

Line 4015: FROM jtf_rs_group_members grp,

4011:
4012: CURSOR get_valid_owner IS
4013: SELECT res.resource_name, res.resource_id, 'RS_' || res.category,
4014: DECODE(res.category, 'EMPLOYEE', res.support_site_id, NULL)
4015: FROM jtf_rs_group_members grp,
4016: cs_jtf_rs_resource_extns_sec res
4017: -- jtf_rs_resource_extns_tl res; Replaced with CS Secure view
4018: WHERE grp.resource_id = p_owner_id
4019: AND grp.group_id = p_owner_group_id