DBA Data[Home] [Help]

APPS.CS_SR_WF_DUP_CHK_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 969: FROM cs_incidents_all_vl inc ,jtf_rs_resource_extns emp

965: l_API_ERROR EXCEPTION;
966:
967: CURSOR l_ServiceRequest_csr IS
968: SELECT emp.source_id incident_owner_id
969: FROM cs_incidents_all_vl inc ,jtf_rs_resource_extns emp
970: WHERE inc.INCIDENT_OWNER_ID = emp.resource_id AND
971: incident_id = l_incident_id;
972:
973: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;

Line 977: FROM cug_sr_type_dup_chk_info maps, cs_incidents_all_b sr, jtf_rs_resource_extns emp

973: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
974:
975: CURSOR l_EA_Recipient_notify_csr IS
976: SELECT emp.source_id incident_owner_id
977: FROM cug_sr_type_dup_chk_info maps, cs_incidents_all_b sr, jtf_rs_resource_extns emp
978: WHERE maps.incident_type_id = sr.incident_type_id
979: AND maps.resource_id = emp.resource_id
980: AND sr.incident_id = l_incident_id;
981: