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_EFFECTIVITIES_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 339: l_status_code ahl_unit_effectivities_b.status_code%TYPE;

335: l_accomplishment_date DATE;
336: l_copy_accomplishment_flag ahl_mr_headers_b.copy_accomplishment_flag%TYPE;
337: l_mr_title ahl_mr_headers_b.title%TYPE;
338: l_version_number NUMBER;
339: l_status_code ahl_unit_effectivities_b.status_code%TYPE;
340:
341: -- Added for deferral functionality.
342: l_affect_due_calc_flag VARCHAr2(1);
343: l_deferral_effective_on DATE;

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 1261: l_status_code ahl_unit_effectivities_b.status_code%TYPE;

1257: l_accomplishment_date DATE;
1258: l_copy_accomplishment_flag ahl_mr_headers_b.copy_accomplishment_flag%TYPE;
1259: l_mr_title ahl_mr_headers_b.title%TYPE;
1260: l_version_number NUMBER;
1261: l_status_code ahl_unit_effectivities_b.status_code%TYPE;
1262:
1263: -- Added for deferral functionality.
1264: l_affect_due_calc_flag VARCHAr2(1);
1265: l_deferral_effective_on DATE;

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'

Line 1499: l_status_code ahl_unit_effectivities_b.status_code%TYPE;

1495: l_accomplishment_date DATE;
1496: l_copy_accomplishment_flag ahl_mr_headers_b.copy_accomplishment_flag%TYPE;
1497: l_mr_title ahl_mr_headers_b.title%TYPE;
1498: l_version_number NUMBER;
1499: l_status_code ahl_unit_effectivities_b.status_code%TYPE;
1500:
1501: -- Added for deferral functionality.
1502: l_affect_due_calc_flag VARCHAr2(1);
1503: l_deferral_effective_on DATE;