APPS.AHL_VWP_TASKS_PVT dependencies on AHL_UNIT_EFFECTIVITIES_VL

Line 747: SELECT MR_Interval_Id, Due_Date FROM AHL_UNIT_EFFECTIVITIES_VL

743: c_task_data_rec c_task_data%ROWTYPE;
744:
745: -- To find task's unit effectivity related information
746: CURSOR c_unit_effectivity (p_ue_id IN NUMBER) IS
747: SELECT MR_Interval_Id, Due_Date FROM AHL_UNIT_EFFECTIVITIES_VL
748: WHERE (STATUS_CODE IS NULL OR STATUS_CODE IN ('INIT-DUE', 'DEFERRED'))
749: AND UNIT_EFFECTIVITY_ID = p_ue_id;
750: c_unit_effectivity_rec c_unit_effectivity%ROWTYPE;
751:

Line 7522: SELECT csi_item_instance_id FROM AHL_UNIT_EFFECTIVITIES_VL

7518: WHERE instance_id = p_instance_id;
7519:
7520: --To fetch instance id for 'Planned' MRs
7521: CURSOR c_get_instance_id (p_unit_effectivity IN NUMBER) IS
7522: SELECT csi_item_instance_id FROM AHL_UNIT_EFFECTIVITIES_VL
7523: WHERE UNIT_EFFECTIVITY_ID = p_unit_effectivity;
7524: -- End changes by rnahata for Issue 105
7525:
7526: BEGIN