APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_JTF_RS_RESOURCE_EXTNS_SEC

Line 4018: cs_jtf_rs_resource_extns_sec res

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

Line 4048: FROM cs_jtf_rs_resource_extns_sec res

4044: ELSE
4045: SELECT resource_name, resource_id , 'RS_' || res.category,
4046: DECODE(res.category, 'EMPLOYEE', res.support_site_id, NULL)
4047: INTO x_owner_name, x_owner_id, x_resource_type, x_support_site_id
4048: FROM cs_jtf_rs_resource_extns_sec res
4049: -- FROM jtf_rs_resource_extns_vl res; Replaced with CS secure view
4050: WHERE res.resource_id = p_owner_id
4051: AND trunc(sysdate) between trunc(nvl(start_date_active, sysdate))
4052: and trunc(nvl(end_date_active, sysdate));