APPS.AHL_VWP_TASKS_PVT dependencies on AHL_UNIT_EFFECTIVITIES_VL

Line 865: SELECT MR_Interval_Id, Due_Date FROM AHL_UNIT_EFFECTIVITIES_VL

861: c_task_data_rec c_task_data%ROWTYPE;
862:
863: -- To find task's unit effectivity related information
864: CURSOR c_unit_effectivity (p_ue_id IN NUMBER) IS
865: SELECT MR_Interval_Id, Due_Date FROM AHL_UNIT_EFFECTIVITIES_VL
866: WHERE (STATUS_CODE IS NULL OR STATUS_CODE IN ('INIT-DUE', 'DEFERRED'))
867: AND UNIT_EFFECTIVITY_ID = p_ue_id;
868: c_unit_effectivity_rec c_unit_effectivity%ROWTYPE;
869:

Line 8830: SELECT csi_item_instance_id FROM AHL_UNIT_EFFECTIVITIES_VL

8826: WHERE instance_id = p_instance_id;
8827:
8828: --To fetch instance id for 'Planned' MRs
8829: CURSOR c_get_instance_id (p_unit_effectivity IN NUMBER) IS
8830: SELECT csi_item_instance_id FROM AHL_UNIT_EFFECTIVITIES_VL
8831: WHERE UNIT_EFFECTIVITY_ID = p_unit_effectivity;
8832: -- End changes by rnahata for Issue 105
8833:
8834: --Kasridha:Changes for Component Maintenance Planning Begins