APPS.OKS_COVERAGE_MIGRATION dependencies on OKS_COVERAGE_TIMES

Line 998: AND NOT EXISTS (Select COV_TZE_LINE_ID from OKS_COVERAGE_TIMES where COV_TZE_LINE_ID= CTZ.ID);

994: AND RUL.ID = CVT.RUL_ID
995: AND CVT.TVE_ID = TIMES.ID
996: --AND Times.Attribute15 IS NULL
997: AND Times.rowid BETWEEN l_start_rowid and l_end_rowid
998: AND NOT EXISTS (Select COV_TZE_LINE_ID from OKS_COVERAGE_TIMES where COV_TZE_LINE_ID= CTZ.ID);
999:
1000:
1001: CURSOR get_Coverage_time_Cur (l_tve_id IN NUMBER) IS
1002: SELECT tve_type,day_of_week,hour,minute

Line 1119: tablename1 := 'oks_coverage_times';

1115:
1116: END LOOP;
1117: END IF;
1118:
1119: tablename1 := 'oks_coverage_times';
1120: -- -- dbms_output.put_line('Value of l_cvtv_tbl_in.COUNT ='||TO_CHAR(l_cvtv_tbl_in.COUNT ));
1121:
1122: IF l_cvtv_tbl_in.COUNT > 0 THEN
1123:

Line 3882: AND NOT EXISTS (Select COV_TZE_LINE_ID from OKS_COVERAGE_TIMES_H where COV_TZE_LINE_ID= CTZ.ID);

3878: AND RGP.MAJOR_VERSION = RUL.MAJOR_VERSION
3879: AND RUL.MAJOR_VERSION = CVT.MAJOR_VERSION
3880: AND CVT.MAJOR_VERSION = TIMES.MAJOR_VERSION
3881: AND Times.rowid BETWEEN l_start_rowid and l_end_rowid
3882: AND NOT EXISTS (Select COV_TZE_LINE_ID from OKS_COVERAGE_TIMES_H where COV_TZE_LINE_ID= CTZ.ID);
3883:
3884:
3885: CURSOR get_Coverage_time_Cur (l_tve_id IN NUMBER) IS
3886: SELECT tve_type,day_of_week,hour,minute

Line 4055: tablename1 := 'oks_coverage_times';

4051:
4052: END LOOP;
4053: END IF;
4054:
4055: tablename1 := 'oks_coverage_times';
4056:
4057: -- dbms_output.put_line('Value of i_cvtv_tbl_in.COUNT='||TO_CHAR(i_cvtv_tbl_in.COUNT));
4058:
4059: IF i_cvtv_tbl_in.COUNT > 0 THEN

Line 4101: INSERT INTO OKS_COVERAGE_TIMES_H(

4097: l_status := 'Before Insert';
4098:
4099: FORALL I IN 1 .. l_tabsize
4100:
4101: INSERT INTO OKS_COVERAGE_TIMES_H(
4102: ID,
4103: DNZ_CHR_ID,
4104: COV_TZE_LINE_ID,
4105: START_HOUR,