DBA Data[Home] [Help]

APPS.AHL_UMP_NONROUTINES_PVT dependencies on CS_INCIDENT_TYPES_VL

Line 2907: FROM cs_incident_types_vl

2903: THEN
2904: BEGIN
2905: SELECT incident_type_id
2906: INTO p_x_nonroutine_rec.type_id
2907: FROM cs_incident_types_vl
2908: WHERE name = p_x_nonroutine_rec.type_name and
2909: cmro_flag = 'Y' and
2910: incident_subtype = 'INC' and
2911: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));

Line 3241: FROM cs_incident_types_vl

3237: -- get default incident type.
3238: cursor default_incident_type_csr
3239: is
3240: SELECT INCIDENT_TYPE_ID
3241: FROM cs_incident_types_vl
3242: where INCIDENT_SUBTYPE = 'INC'
3243: AND CMRO_FLAG = 'Y'
3244: AND incident_type_id=fnd_profile.value('AHL_MCL_M_AND_O_SR_TYPE')
3245: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate))