eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UMP_UTIL_PKG dependencies on AHL_UNIT_DEFERRALS_B

Line 319: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def, ahl_unit_deferrals_b ter

315: SELECT * FROM (
316: SELECT ue.accomplished_date, ue.unit_effectivity_id, ue.status_code,
317: decode(ue.status_code, 'TERMINATED', ter.affect_due_calc_flag, def.affect_due_calc_flag),
318: decode(ue.status_code, 'TERMINATED', ter.deferral_effective_on, def.deferral_effective_on)
319: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def, ahl_unit_deferrals_b ter
320: WHERE ue.defer_from_ue_id = def.unit_effectivity_id (+)
321: AND ue.unit_effectivity_id = ter.unit_effectivity_id(+)
322: AND ue.status_code IN ('ACCOMPLISHED','INIT-ACCOMPLISHED','TERMINATED')
323: AND def.unit_deferral_type(+) = 'DEFERRAL'

Line 1245: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def

1241: p_mr_header_id IN NUMBER) IS
1242: SELECT * FROM (
1243: SELECT ue.accomplished_date, ue.unit_effectivity_id, ue.status_code,
1244: affect_due_calc_flag, deferral_effective_on
1245: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def
1246: WHERE ue.defer_from_ue_id = def.unit_effectivity_id (+)
1247: AND ue.status_code IN ('ACCOMPLISHED','INIT-ACCOMPLISHED')
1248: AND ue.csi_item_instance_id = p_csi_item_instance_id
1249: AND ue.mr_header_id = p_mr_header_id

Line 1479: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def, ahl_unit_deferrals_b ter

1475: SELECT * FROM (
1476: SELECT ue.accomplished_date, ue.unit_effectivity_id, ue.status_code,
1477: decode(ue.status_code, 'TERMINATED', ter.affect_due_calc_flag, def.affect_due_calc_flag),
1478: decode(ue.status_code, 'TERMINATED', ter.deferral_effective_on, def.deferral_effective_on)
1479: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def, ahl_unit_deferrals_b ter
1480: WHERE ue.defer_from_ue_id = def.unit_effectivity_id (+)
1481: AND ue.unit_effectivity_id = ter.unit_effectivity_id(+)
1482: AND ue.status_code IN ('ACCOMPLISHED','INIT-ACCOMPLISHED','TERMINATED')
1483: AND def.unit_deferral_type(+) = 'DEFERRAL'