DBA Data[Home] [Help]

APPS.CS_SR_WF_DUP_CHK_PVT dependencies on CS_INCIDENTS_ALL_VL

Line 990: FROM cs_incidents_all_vl inc ,jtf_rs_resource_extns emp

986: l_API_ERROR EXCEPTION;
987:
988: CURSOR l_ServiceRequest_csr IS
989: SELECT emp.source_id incident_owner_id
990: FROM cs_incidents_all_vl inc ,jtf_rs_resource_extns emp
991: WHERE inc.INCIDENT_OWNER_ID = emp.resource_id AND
992: incident_id = l_incident_id;
993:
994: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;