DBA Data[Home] [Help]

APPS.OKS_RULE_MIGRATE dependencies on OKC_COVER_TIMES_H

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