DBA Data[Home] [Help]

APPS.OKS_COVERAGE_MIGRATION dependencies on OKS_COVERAGE_TIMES_H

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 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,