DBA Data[Home] [Help]

APPS.AHL_UMP_NONROUTINES_PVT dependencies on CS_INCIDENT_TYPES_VL

Line 3024: FROM cs_incident_types_vl

3020: THEN
3021: BEGIN
3022: SELECT incident_type_id
3023: INTO p_x_nonroutine_rec.type_id
3024: FROM cs_incident_types_vl
3025: WHERE name = p_x_nonroutine_rec.type_name and
3026: cmro_flag = 'Y' and
3027: incident_subtype = 'INC' and
3028: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));

Line 3399: FROM cs_incident_types_vl

3395: -- get default incident type.
3396: cursor default_incident_type_csr
3397: is
3398: SELECT INCIDENT_TYPE_ID
3399: FROM cs_incident_types_vl
3400: where INCIDENT_SUBTYPE = 'INC'
3401: AND CMRO_FLAG = 'Y'
3402: AND incident_type_id=fnd_profile.value('AHL_MCL_M_AND_O_SR_TYPE')
3403: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate))