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.

[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UNIT_EFFECTIVITIES_VL

Line 158: FROM ahl_unit_effectivities_vl

154: LAST_UPDATED_BY ,
155: LAST_UPDATE_LOGIN
156:
157: --FROM ahl_unit_effectivities_app_v
158: FROM ahl_unit_effectivities_vl
159: WHERE unit_effectivity_id = p_unit_effectivity_id;
160: --FOR UPDATE OF preceding_ue_id, status_code NOWAIT; -- not required as these rows were locked before.
161:
162: -- Cursor for reading unit effectivity records(top nodes) that have not been updated.

Line 1434: FROM ahl_unit_effectivities_vl

1430: ATTRIBUTE14 ,
1431: ATTRIBUTE15 ,
1432: OBJECT_VERSION_NUMBER
1433: --FROM ahl_unit_effectivities_app_v
1434: FROM ahl_unit_effectivities_vl
1435: WHERE unit_effectivity_id = p_unit_effectivity_id;
1436: --FOR UPDATE OF due_date NOWAIT;
1437:
1438: TYPE temp_grp_rec_type IS RECORD (

Line 1872: FROM ahl_unit_effectivities_vl

1868: ATTRIBUTE13 ,
1869: ATTRIBUTE14 ,
1870: ATTRIBUTE15 ,
1871: OBJECT_VERSION_NUMBER
1872: FROM ahl_unit_effectivities_vl
1873: WHERE unit_effectivity_id = p_unit_effectivity_id;
1874: --FOR UPDATE OF due_date NOWAIT; -- not required as we locked the UEs before
1875:
1876: -- Get all mr-terminated children under the SR-UE.