DBA Data[Home] [Help]

APPS.CS_SR_WF_DUP_CHK_PVT dependencies on JTF_RS_RESOURCE_EXTNS

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;

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

994: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
995:
996: CURSOR l_EA_Recipient_notify_csr IS
997: SELECT emp.source_id incident_owner_id
998: FROM cug_sr_type_dup_chk_info maps, cs_incidents_all_b sr, jtf_rs_resource_extns emp
999: WHERE maps.incident_type_id = sr.incident_type_id
1000: AND maps.resource_id = emp.resource_id
1001: AND sr.incident_id = l_incident_id;
1002: