APPS.CUG_GENERIC_WF_PKG dependencies on CS_SR_OWNERS_V

Line 229: select resource_name, resource_type from cs_sr_owners_v where

225:
226:
227: /* 2576759 - BEGIN - Added resource_type check in the where clause */
228: CURSOR l_GetResourceName_csr IS
229: select resource_name, resource_type from cs_sr_owners_v where
230: resource_id = l_default_owner_id and
231: resource_type = 'RS_EMPLOYEE';
232: /* 2576759 - END - Added resource_type check in the where clause */
233: l_GetResourceName_rec l_GetResourceName_csr%ROWTYPE;

Line 1978: FROM cs_incidents_all_vl inc ,cs_sr_owners_v owner, jtf_rs_resource_extns emp

1974: l_API_ERROR EXCEPTION;
1975:
1976: CURSOR l_ServiceRequest_csr IS
1977: SELECT inc.customer_product_id, inc.expected_resolution_date,inc.inventory_item_id,inc.summary, emp.source_id incident_owner_id
1978: FROM cs_incidents_all_vl inc ,cs_sr_owners_v owner, jtf_rs_resource_extns emp
1979: WHERE inc.INCIDENT_OWNER_ID = owner.resource_id(+) AND
1980: emp.resource_id = owner.resource_id AND
1981: incident_id = l_request_id;
1982: