APPS.AHL_VWP_TASKS_PVT dependencies on AHL_MR_INTERVALS_APP_V

Line 896: FROM Ahl_MR_Intervals_APP_V WHERE MR_Interval_Id=p_interval_id;

892:
893: -- To find task's unit effectivity tolerance related information
894: CURSOR c_tolerance (p_interval_id IN NUMBER) IS
895: SELECT Tolerance_Before, Tolerance_After
896: FROM Ahl_MR_Intervals_APP_V WHERE MR_Interval_Id=p_interval_id;
897: c_tolerance_rec c_tolerance%ROWTYPE;
898:
899: -- To find task's unit effectivity unit of measure related information
900: /* CURSOR c_unitofmeasure (l_tol_before IN NUMBER, l_tol_after IN NUMBER) IS

Line 902: FROM MTL_Units_Of_Measure_vl UOM, CS_Counters C, Ahl_MR_Intervals_APP_V MRI

898:
899: -- To find task's unit effectivity unit of measure related information
900: /* CURSOR c_unitofmeasure (l_tol_before IN NUMBER, l_tol_after IN NUMBER) IS
901: SELECT UOM.Unit_of_Measure
902: FROM MTL_Units_Of_Measure_vl UOM, CS_Counters C, Ahl_MR_Intervals_APP_V MRI
903: WHERE UOM.Uom_Code = C.Uom_Code AND C.Counter_Id = MRI.Counter_Id AND
904: Tolerance_Before = l_tol_before AND Tolerance_After = l_tol_after;
905: */
906: -- AnRaj: Changed query for perf issue#5, Bug 4919465