DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENT_STATUSES_VL

Line 2037: FROM cs_incident_statuses_vl

2033: stops stamping of incident_resolved_date and inc_responded_by_date to audit rec
2034: smisra 12/31/2003
2035: SELECT responded_flag,resolved_flag
2036: INTO l_responded_flag,l_resolved_flag
2037: FROM cs_incident_statuses_vl
2038: WHERE incident_status_id=l_service_request_rec.status_id ;
2039:
2040: IF ((l_responded_flag='Y') OR (l_resolved_flag ='Y')) THEN
2041: IF((l_responded_flag='Y' ) AND (l_service_request_rec.inc_responded_by_date is NULL OR

Line 12300: FROM cs_incident_statuses_vl

12296: -- For bug 3512501 - added begin..exception
12297: begin
12298: SELECT responded_flag,resolved_flag
12299: INTO l_responded_flag,l_resolved_flag
12300: FROM cs_incident_statuses_vl
12301: WHERE incident_status_id=l_service_request_rec.status_id ;
12302: exception
12303: when no_data_found then
12304: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,