APPS.AHL_PRD_NONROUTINE_PVT dependencies on CS_INCIDENT_TYPES_VL

Line 1914: FROM cs_incident_types_vl

1910: AND B.workorder_id = p_workorder_id;
1911:
1912: CURSOR default_incident_type_id is
1913: SELECT INCIDENT_TYPE_ID,NAME
1914: FROM cs_incident_types_vl
1915: where INCIDENT_SUBTYPE = 'INC'
1916: AND CMRO_FLAG = 'Y'
1917: -- Check added by balaji for bug # 4146503.
1918: -- always has to pick up the SR type id from AHL default SR Type profile.

Line 2515: FROM cs_incident_types_vl

2511: l_unit_effectivity_id NUMBER;
2512: CURSOR GetRequestType(c_req_type_id NUMBER)
2513: Is
2514: Select name
2515: FROM cs_incident_types_vl
2516: WHERE incident_type_id = c_req_type_id;
2517: CURSOR GetOrgTaskDet(c_org_wo_id NUMBER)
2518: Is
2519: Select visit_task_id