APPS.AHL_VWP_TASKS_PVT dependencies on AHL_MR_INTERVALS_APP_V

Line 778: FROM Ahl_MR_Intervals_APP_V WHERE MR_Interval_Id=p_interval_id;

774:
775: -- To find task's unit effectivity tolerance related information
776: CURSOR c_tolerance (p_interval_id IN NUMBER) IS
777: SELECT Tolerance_Before, Tolerance_After
778: FROM Ahl_MR_Intervals_APP_V WHERE MR_Interval_Id=p_interval_id;
779: c_tolerance_rec c_tolerance%ROWTYPE;
780:
781: -- To find task's unit effectivity unit of measure related information
782: /* CURSOR c_unitofmeasure (l_tol_before IN NUMBER, l_tol_after IN NUMBER) IS

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

780:
781: -- To find task's unit effectivity unit of measure related information
782: /* CURSOR c_unitofmeasure (l_tol_before IN NUMBER, l_tol_after IN NUMBER) IS
783: SELECT UOM.Unit_of_Measure
784: FROM MTL_Units_Of_Measure_vl UOM, CS_Counters C, Ahl_MR_Intervals_APP_V MRI
785: WHERE UOM.Uom_Code = C.Uom_Code AND C.Counter_Id = MRI.Counter_Id AND
786: Tolerance_Before = l_tol_before AND Tolerance_After = l_tol_after;
787: */
788: -- AnRaj: Changed query for perf issue#5, Bug 4919465