APPS.OKS_RULE_MIGRATE dependencies on OKS_COVERAGE_TIMEZONES_H

Line 37839: WHERE COV_TZE_LINE_ID IN (SELECT ID FROM OKS_COVERAGE_TIMEZONES_H

37835: Delete from oks_k_lines_bh where cle_id = P_Cle_ID and major_version = L_MAJOR_VERSION;
37836: END IF;
37837:
37838: DELETE OKS_COVERAGE_TIMES_H
37839: WHERE COV_TZE_LINE_ID IN (SELECT ID FROM OKS_COVERAGE_TIMEZONES_H
37840: WHERE CLE_ID = L_CLE_ID AND MAJOR_VERSION = L_MAJOR_VERSION
37841: AND DNZ_CHR_ID = L_DNZ_CHR_ID)
37842: AND MAJOR_VERSION = L_MAJOR_VERSION
37843: AND DNZ_CHR_ID = L_DNZ_CHR_ID;

Line 37845: DELETE OKS_COVERAGE_TIMEZONES_H

37841: AND DNZ_CHR_ID = L_DNZ_CHR_ID)
37842: AND MAJOR_VERSION = L_MAJOR_VERSION
37843: AND DNZ_CHR_ID = L_DNZ_CHR_ID;
37844:
37845: DELETE OKS_COVERAGE_TIMEZONES_H
37846: WHERE CLE_ID = L_CLE_ID
37847: AND DNZ_CHR_ID = L_DNZ_CHR_ID
37848: AND MAJOR_VERSION = L_MAJOR_VERSION;
37849:

Line 37851: INSERT INTO OKS_COVERAGE_TIMEZONES_H oct (

37847: AND DNZ_CHR_ID = L_DNZ_CHR_ID
37848: AND MAJOR_VERSION = L_MAJOR_VERSION;
37849:
37850:
37851: INSERT INTO OKS_COVERAGE_TIMEZONES_H oct (
37852: id, cle_id, dnz_chr_id, timezone_id, default_yn, created_by,
37853: creation_date, last_updated_by, last_update_date,
37854: last_update_login, security_group_id, program_application_id,
37855: program_id, program_update_date, request_id, object_version_number,major_version)

Line 37899: oks_coverage_timezones_h tze

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
37901: and cvt.rul_id = rules.id
37902: and time_val.dnz_chr_id = cvt.dnz_chr_id
37903: and rules.rule_information_category = 'CVR'