eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_RULE_MIGRATE dependencies on OKS_COVERAGE_TIMEZONES

Line 37749: WHERE COV_TZE_LINE_ID IN (SELECT ID FROM OKS_COVERAGE_TIMEZONES

37745: Delete from oks_k_lines_b where cle_id = L_Cle_ID;
37746: END IF;
37747:
37748: DELETE OKS_COVERAGE_TIMES
37749: WHERE COV_TZE_LINE_ID IN (SELECT ID FROM OKS_COVERAGE_TIMEZONES
37750: WHERE CLE_ID = L_CLE_ID AND DNZ_CHR_ID = L_DNZ_CHR_ID)
37751: AND DNZ_CHR_ID = L_DNZ_CHR_ID;
37752:
37753: DELETE OKS_COVERAGE_TIMEZONES

Line 37753: DELETE OKS_COVERAGE_TIMEZONES

37749: WHERE COV_TZE_LINE_ID IN (SELECT ID FROM OKS_COVERAGE_TIMEZONES
37750: WHERE CLE_ID = L_CLE_ID AND DNZ_CHR_ID = L_DNZ_CHR_ID)
37751: AND DNZ_CHR_ID = L_DNZ_CHR_ID;
37752:
37753: DELETE OKS_COVERAGE_TIMEZONES
37754: WHERE CLE_ID = L_CLE_ID
37755: AND DNZ_CHR_ID = L_DNZ_CHR_ID;
37756:
37757: --COMMIT;

Line 37761: insert into oks_coverage_timezones oct (

37757: --COMMIT;
37758:
37759:
37760:
37761: insert into oks_coverage_timezones oct (
37762: id, cle_id, dnz_chr_id, timezone_id, default_yn, created_by,
37763: creation_date, last_updated_by, last_update_date,
37764: last_update_login, security_group_id, program_application_id,
37765: program_id, program_update_date, request_id, object_version_number)

Line 37806: oks_coverage_timezones tze

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
37808: and cvt.rul_id = rules.id
37809: and time_val.dnz_chr_id = cvt.dnz_chr_id
37810: and rules.rule_information_category = 'CVR'

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'