DBA Data[Home] [Help]

APPS.CS_SR_WF_DUP_CHK_PVT dependencies on CUG_SR_TYPE_DUP_CHK_INFO

Line 225: FROM cug_sr_type_dup_chk_info conf, cs_incidents_all_b inc

221: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
222:
223: CURSOR l_EA_Dup_Chk_csr IS
224: SELECT conf.sr_dup_check_flag
225: FROM cug_sr_type_dup_chk_info conf, cs_incidents_all_b inc
226: WHERE conf.incident_type_id = inc.incident_type_id
227: AND inc.incident_id = l_incident_id;
228:
229: CURSOR l_EA_Attr_csr IS

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: