APPS.AHL_PRD_NONROUTINE_PVT dependencies on CS_INCIDENT_TYPES_VL

Line 2100: FROM cs_incident_types_vl

2096: AND B.workorder_id = p_workorder_id;
2097:
2098: CURSOR default_incident_type_id is
2099: SELECT INCIDENT_TYPE_ID,NAME
2100: FROM cs_incident_types_vl
2101: where INCIDENT_SUBTYPE = 'INC'
2102: AND CMRO_FLAG = 'Y'
2103: -- Check added by balaji for bug # 4146503.
2104: -- always has to pick up the SR type id from AHL default SR Type profile.

Line 2113: FROM cs_incident_types_vl

2109:
2110: -- added to fix bug# 8265902
2111: CURSOR get_inc_type_id (p_name IN VARCHAR2) IS
2112: SELECT INCIDENT_TYPE_ID
2113: FROM cs_incident_types_vl
2114: where INCIDENT_SUBTYPE = 'INC'
2115: AND CMRO_FLAG = 'Y'
2116: AND NAME = p_name
2117: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate))

Line 3180: FROM cs_incident_types_vl

3176: l_unit_effectivity_id NUMBER;
3177: CURSOR GetRequestType(c_req_type_id NUMBER)
3178: Is
3179: Select name
3180: FROM cs_incident_types_vl
3181: WHERE incident_type_id = c_req_type_id;
3182: CURSOR GetOrgTaskDet(c_org_wo_id NUMBER)
3183: Is
3184: Select visit_task_id