APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_UNIT_EFFECTIVITIES_APP_V

Line 780: SELECT STATUS_CODE,OBJECT_TYPE FROM AHL_UNIT_EFFECTIVITIES_APP_V

776:
777: -- get the status code of the UE before deleting it.
778: Cursor GetStatusCode(c_ue_id NUMBER)
779: IS
780: SELECT STATUS_CODE,OBJECT_TYPE FROM AHL_UNIT_EFFECTIVITIES_APP_V
781: WHERE UNIT_EFFECTIVITY_ID = c_ue_id
782: and MANUALLY_PLANNED_FLAG = 'Y';
783:
784: -- Declare local variables