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 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: