APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_UNIT_EFFECTIVITIES_APP_V

Line 706: SELECT STATUS_CODE,OBJECT_TYPE FROM AHL_UNIT_EFFECTIVITIES_APP_V

702:
703: -- get the status code of the UE before deleting it.
704: Cursor GetStatusCode(c_ue_id NUMBER)
705: IS
706: SELECT STATUS_CODE,OBJECT_TYPE FROM AHL_UNIT_EFFECTIVITIES_APP_V
707: WHERE UNIT_EFFECTIVITY_ID = c_ue_id
708: and MANUALLY_PLANNED_FLAG = 'Y';
709:
710: -- Declare local variables