APPS.OKS_RULE_MIGRATE dependencies on OKC_TIMEVALUES_BH

Line 37500: FROM okc_timevalues_bh TIM,okc_timevalues_bh TIM2 ,okc_rules_bh Rul,OKC_RULE_GROUPS_BH RGP

37496: AND RGP.ID = L_RGP_ID;
37497:
37498: Cursor Cur_Off_Period_H(l_cleid in number,l_rgp_id IN NUMBER,l_major_version IN NUMBER) IS
37499: SELECT TIM2.UOM_CODE,TIM2.DURATION
37500: FROM okc_timevalues_bh TIM,okc_timevalues_bh TIM2 ,okc_rules_bh Rul,OKC_RULE_GROUPS_BH RGP
37501: WHERE RGP.CLE_ID = l_cle_id
37502: AND RUL.rule_information1 = TIM.Id
37503: AND RUL.rule_information_category = 'OFS'
37504: AND RGP.ID = RUL.RGP_ID

Line 37629: FROM okc_timevalues_bh TIM ,okc_timevalues_bh TIM2,okc_rules_bh Rul,OKC_RULE_GROUPS_BH RGP

37625:
37626: UPDATE OKS_K_LINES_BH T1
37627: SET (T1.offset_period ,T1.offset_duration) =
37628: (SELECT TIM2.UOM_CODE,TIM2.DURATION
37629: FROM okc_timevalues_bh TIM ,okc_timevalues_bh TIM2,okc_rules_bh Rul,OKC_RULE_GROUPS_BH RGP
37630: WHERE RGP.CLE_ID = l_cle_id
37631: AND RUL.rule_information1 = TIM.Id
37632: AND RUL.rule_information_category = 'OFS'
37633: AND RGP.ID = RUL.RGP_ID

Line 37860: okc_timevalues_bh times,

37856: select distinct rgp.cle_id, rgp.cle_id, rgp.dnz_chr_id, times.tze_id, 'Y',
37857: 1, sysdate, 1, sysdate, 2003, null, null, null, null, null,1, times.major_version
37858: from okc_rule_groups_bh rgp,
37859: okc_rules_bh rules,
37860: okc_timevalues_bh times,
37861: okc_cover_times_h cvt
37862: where rgp.id = rules.rgp_id
37863: and rgp.dnz_chr_id = rules.dnz_chr_id
37864: and rules.rule_information_category = 'CVR'

Line 38534: from okc_timevalues_bh tim,

38530: max(decode( tim.day_of_week, 'THU', rin.duration)),
38531: max(decode( tim.day_of_week, 'FRI', rin.duration)),
38532: max(decode( tim.day_of_week, 'SAT', rin.duration)), 'MIN', 1, sysdate, 1,
38533: sysdate, 2003, null, null, null, null, null,1, tim.major_version
38534: from okc_timevalues_bh tim,
38535: okc_react_intervals_h rin,
38536: okc_rules_bh rul,
38537: okc_rule_groups_bh rgp,
38538: oks_action_time_types_h att