APPS.OKS_COVERAGE_MIGRATION dependencies on OKC_TIMEVALUES_V

Line 132: FROM OKC_TIMEVALUES_V

128: x_period OUT NOCOPY VARCHAR2) IS
129:
130: CURSOR Csr_get_duration (l_ID IN NUMBER) IS
131: SELECT UOM_CODE,Duration
132: FROM OKC_TIMEVALUES_V
133: WHERE id = l_id;
134:
135: Lx_Duration NUMBER := NULL;
136: Lx_Period VARCHAR2(100) := NULL;

Line 515: FROM OKC_TIMEVALUES_V

511: x_period OUT NOCOPY VARCHAR2) IS
512:
513: CURSOR Csr_get_duration (l_ID IN NUMBER) IS
514: SELECT UOM_CODE,Duration
515: FROM OKC_TIMEVALUES_V
516: WHERE id = l_id;
517:
518: Lx_Duration NUMBER := NULL;
519: Lx_Period VARCHAR2(100) := NULL;

Line 570: FROM okc_timevalues_v times,

566: Times.Created_By Times_Created_By,
567: Times.Last_Updated_By Times_Last_Updated_By,
568: Times.Last_Update_Date Times_Last_Update_Date,
569: Times.Last_Update_Login Times_Last_Update_Login
570: FROM okc_timevalues_v times,
571: okc_cover_times cvt
572: WHERE CVT.tve_ID = TIMES.id
573: AND CVT.rul_id = rule_id
574: AND rownum = 1;

Line 1003: FROM okc_timevalues_v

999:
1000:
1001: CURSOR get_Coverage_time_Cur (l_tve_id IN NUMBER) IS
1002: SELECT tve_type,day_of_week,hour,minute
1003: FROM okc_timevalues_v
1004: WHERE ID = l_tve_id;
1005:
1006: TYPE Vc420_Tbl_Type IS VARRAY(1000) OF VARCHAR2(420);
1007: TYPE Num_Tbl_Type IS VARRAY(1000) OF NUMBER;

Line 1557: okc_timevalues_v TIM,okc_react_intervals RIN

1553: TIM.TVE_TYPE TVE_TYPE,
1554: Rul.ID RUL_ID
1555: FROM oks_action_time_types_v TYP,
1556: okc_rule_groups_V RGP,okc_rules_v RUL,
1557: okc_timevalues_v TIM,okc_react_intervals RIN
1558: WHERE RGP.CLE_ID = TYP.CLE_ID
1559: AND RGP.DNZ_CHR_ID = TYP.DNZ_CHR_ID
1560: AND RGP.ID = RUL.RGP_ID
1561: -- AND typ.id = 308454467546072904212144662892351929683

Line 2665: FROM OKC_TIMEVALUES_V

2661: x_period OUT NOCOPY VARCHAR2) IS
2662:
2663: CURSOR get_duration (l_ID IN NUMBER) IS
2664: SELECT UOM_CODE,Duration
2665: FROM OKC_TIMEVALUES_V
2666: WHERE id = l_id;
2667:
2668: Lx_Duration NUMBER := NULL;
2669: Lx_Period VARCHAR2(100) := NULL;