APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_SR_NON_ROUTINES_V

Line 2966: FROM AHL_SR_NON_ROUTINES_V

2962: --Cursor to find duplicate Removal NR for same instance during create
2963: CURSOR cr_duplicate_removal_nr(c_instance_id IN NUMBER)
2964: IS
2965: SELECT sr_incident_number
2966: FROM AHL_SR_NON_ROUTINES_V
2967: WHERE UE_CSI_INSTANCE_ID = c_instance_id
2968: AND nvl2(fnd_profile.VALUE('AHL_REMOVAL_NON_ROUTINE'), SR_INCIDENT_TYPE_ID, 1) = nvl(fnd_profile.VALUE('AHL_REMOVAL_NON_ROUTINE'),2)
2969: AND SR_INCIDENT_STATUS NOT IN ('Canceled', 'Cancelled by User', 'Closed');
2970:

Line 2975: FROM AHL_SR_NON_ROUTINES_V

2971: --Cursor to find duplicate Removal NR for same instance during update
2972: CURSOR upd_duplicate_removal_nr(c_instance_id IN NUMBER, c_sr_incident_id IN NUMBER)
2973: IS
2974: SELECT sr_incident_number
2975: FROM AHL_SR_NON_ROUTINES_V
2976: WHERE UE_CSI_INSTANCE_ID = c_instance_id
2977: AND nvl2(fnd_profile.VALUE('AHL_REMOVAL_NON_ROUTINE'), SR_INCIDENT_TYPE_ID, 1) = nvl(fnd_profile.VALUE('AHL_REMOVAL_NON_ROUTINE'),2)
2978: AND SR_INCIDENT_STATUS NOT IN ('Canceled', 'Cancelled by User', 'Closed')
2979: AND SR_INCIDENT_ID NOT IN (c_sr_incident_id);