APPS.OKS_COVERAGE_MIGRATION dependencies on OKC_TIMEVALUES_BH

Line 3405: FROM OKC_TIMEVALUES_BH ISE, OKC_TIMEVALUES_BH TAL

3401:
3402:
3403: CURSOR get_duration (l_ID IN NUMBER) IS
3404: SELECT TAL.UOM_CODE,TAL.Duration
3405: FROM OKC_TIMEVALUES_BH ISE, OKC_TIMEVALUES_BH TAL
3406: WHERE ISE.id = l_id
3407: AND ISE.TVE_ID_STARTED = TAL.ID
3408: AND ISE.TVE_TYPE = 'ISE'
3409: AND TAL.TVE_TYPE = 'TAL'

Line 3461: FROM okc_timevalues_bh times,

3457: Times.Last_Update_Date Times_Last_Update_Date,
3458: Times.Last_Update_Login Times_Last_Update_Login,
3459: Times.Object_Version_Number Times_Object_Version_Number,
3460: Times.Major_Version Times_Major_Version
3461: FROM okc_timevalues_bh times,
3462: okc_cover_times_h cvt
3463: WHERE CVT.tve_ID = TIMES.id
3464: AND CVT.rul_id = rule_id
3465: AND rownum = 1;

Line 3869: OKC_TIMEVALUES_BH TIMES

3865: FROM OKS_COVERAGE_TIMEZONES CTZ,
3866: OKC_RULE_GROUPS_BH RGP,
3867: OKC_RULES_BH RUL,
3868: OKC_COVER_TIMES_H CVT,
3869: OKC_TIMEVALUES_BH TIMES
3870: WHERE CTZ.Cle_Id = RGP.CLE_ID
3871: AND CTZ.DNZ_CHR_ID = RGP.DNZ_CHR_ID
3872: AND RGP.ID = RUL.RGP_ID
3873: AND RGP.DNZ_CHR_ID = RUL.DNZ_CHR_ID

Line 3887: FROM okc_timevalues_BH

3883:
3884:
3885: CURSOR get_Coverage_time_Cur (l_tve_id IN NUMBER) IS
3886: SELECT tve_type,day_of_week,hour,minute
3887: FROM okc_timevalues_BH
3888: WHERE ID = l_tve_id;
3889:
3890: TYPE Vc420_Tbl_Type IS VARRAY(1000) OF VARCHAR2(420);
3891: TYPE Num_Tbl_Type IS VARRAY(1000) OF NUMBER;

Line 4681: okc_timevalues_bh TIM,okc_react_intervals_h RIN

4677: Rul.ID RUL_ID,
4678: Rul.major_version Rul_major_version
4679: FROM oks_action_time_types_h TYP,
4680: okc_rule_groups_bh RGP,okc_rules_bh RUL,
4681: okc_timevalues_bh TIM,okc_react_intervals_h RIN
4682: WHERE RGP.CLE_ID = TYP.CLE_ID
4683: AND RGP.DNZ_CHR_ID = TYP.DNZ_CHR_ID
4684: AND RGP.ID = RUL.RGP_ID
4685: AND RGP.DNZ_CHR_ID = RUL.DNZ_CHR_ID