DBA Data[Home] [Help]

APPS.OKS_RULE_MIGRATE dependencies on OKS_COVERAGE_TIMES_H

Line 37838: DELETE OKS_COVERAGE_TIMES_H

37834:
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

Line 37877: INSERT INTO OKS_COVERAGE_TIMES_H oct (

37873: and rgp.major_version = l_major_version;
37874:
37875:
37876:
37877: INSERT INTO OKS_COVERAGE_TIMES_H oct (
37878: id, cov_tze_line_id, dnz_chr_id, start_hour, start_minute,
37879: end_hour, end_minute, monday_yn, tuesday_yn, wednesday_yn,
37880: thursday_yn, friday_yn, saturday_yn, sunday_yn, created_by,
37881: creation_date, last_updated_by, last_update_date,