APPS.AHL_PRD_NONROUTINE_PUB dependencies on CS_INCIDENT_TYPES_VL

Line 663: FROM cs_incidents_all_b CS,cs_incident_types_vl

659:
660: BEGIN
661: SELECT name,incident_subtype
662: INTO x_create_nr_output_rec.SERVICE_REQUEST_TYPE,x_create_nr_output_rec.SERVICE_REQUEST_TYPE_CODE
663: FROM cs_incidents_all_b CS,cs_incident_types_vl
664: WHERE cs.incident_id = p_nr_task_rec.INCIDENT_ID
665: AND cs.incident_type_id = cs_incident_types_vl.incident_type_id;
666: EXCEPTION
667: WHEN OTHERS THEN

Line 665: AND cs.incident_type_id = cs_incident_types_vl.incident_type_id;

661: SELECT name,incident_subtype
662: INTO x_create_nr_output_rec.SERVICE_REQUEST_TYPE,x_create_nr_output_rec.SERVICE_REQUEST_TYPE_CODE
663: FROM cs_incidents_all_b CS,cs_incident_types_vl
664: WHERE cs.incident_id = p_nr_task_rec.INCIDENT_ID
665: AND cs.incident_type_id = cs_incident_types_vl.incident_type_id;
666: EXCEPTION
667: WHEN OTHERS THEN
668: NULL;
669: END;

Line 841: FROM cs_incident_types_vl

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