APPS.OKS_RULE_MIGRATE dependencies on OKC_COVER_TIMES

Line 37772: okc_cover_times cvt

37768: 2003, sysdate, 2003, sysdate, 2003, null, null, null, null, null, 1
37769: from okc_rule_groups_b rgp,
37770: okc_rules_b rules,
37771: okc_timevalues_b times,
37772: okc_cover_times cvt
37773: where rgp.id = rules.rgp_id
37774: and rgp.dnz_chr_id = rules.dnz_chr_id
37775: and rules.rule_information_category = 'CVR'
37776: and rules.id = cvt.rul_id

Line 37803: okc_cover_times cvt,

37799: decode(time_val.start_day_of_week, 'SAT', 'Y', 'N') saturday_yn,
37800: decode(time_val.start_day_of_week, 'SUN', 'Y', 'N' ) sunday_yn, 2003,
37801: sysdate, 2003, sysdate, 2003, null, null, null, null, null, 1
37802: from okc_time_ig_startend_val_v time_val,
37803: okc_cover_times cvt,
37804: okc_rules_b rules,
37805: okc_rule_groups_b rgp,
37806: oks_coverage_timezones tze
37807: where time_val.id = cvt.tve_id

Line 37861: okc_cover_times_h cvt

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'
37865: and rules.id = cvt.rul_id

Line 37896: okc_cover_times_h cvt,

37892: decode(time_val.start_day_of_week, 'SAT', 'Y', 'N') saturday_yn,
37893: decode(time_val.start_day_of_week, 'SUN', 'Y', 'N' ) sunday_yn, 1,
37894: sysdate, 1, sysdate, 2003, null, null, null, null, null,tze.major_version, 1
37895: from oks_covtimes_hist_v time_val, --oks_time_ig_startend_val_hv time_val,
37896: okc_cover_times_h cvt,
37897: okc_rules_bh rules,
37898: okc_rule_groups_bh rgp,
37899: oks_coverage_timezones_h tze
37900: where time_val.id = cvt.tve_id