APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_JTF_RS_RESOURCE_EXTNS_SEC

Line 4016: cs_jtf_rs_resource_extns_sec res

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
4020: AND grp.resource_id = res.resource_id;

Line 4046: FROM cs_jtf_rs_resource_extns_sec res

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