APPS.AHL_PRD_NONROUTINE_PUB dependencies on CS_INCIDENT_TYPES_VL

Line 648: FROM cs_incidents_all_b CS,cs_incident_types_vl cit

644:
645: BEGIN
646: SELECT cit.name,cit.incident_subtype
647: INTO x_create_nr_output_rec.SERVICE_REQUEST_TYPE,x_create_nr_output_rec.SERVICE_REQUEST_TYPE_CODE
648: FROM cs_incidents_all_b CS,cs_incident_types_vl cit
649: WHERE cs.incident_id = p_nr_task_rec.INCIDENT_ID
650: AND cs.incident_type_id = cit.incident_type_id;
651: EXCEPTION
652: WHEN OTHERS THEN

Line 838: FROM cs_incident_types_vl

834: END IF;
835: BEGIN
836: SELECT incident_subtype
837: INTO x_create_nr_output_rec.SERVICE_REQUEST_TYPE_CODE
838: FROM cs_incident_types_vl
839: WHERE incident_Type_id = p_sr_task_rec.type_id;
840: EXCEPTION
841: WHEN OTHERS THEN
842: NULL;