APPS.OKS_COVERAGE_MIGRATION dependencies on OKS_K_LINES_BH

Line 2254: INSERT INTO OKS_K_LINES_BH

2250:
2251:
2252: FORALL I IN 1 .. l_tabsize
2253:
2254: INSERT INTO OKS_K_LINES_BH
2255: (
2256: ID,
2257: MAJOR_VERSION ,
2258: CLE_ID,

Line 2555: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_BH WHERE CLE_ID = LINE.ID)

2551: AND LINE.LSE_ID IN (2,15,20)
2552: -- AND RUL.RULE_INFORMATION_CATEGORY IN ('ECE','WHE','UGE','STR','CVE','PMP')
2553: AND LINE.DNZ_CHR_ID = RGP.DNZ_CHR_ID
2554: -- AND RUL.RULE_INFORMATION15 IS NULL
2555: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_BH WHERE CLE_ID = LINE.ID)
2556: AND Rul.rowid BETWEEN l_start_rowid and l_end_rowid
2557: AND LINE.major_version = RGP.major_version
2558: AND RGP.major_version = RUL.major_version
2559: ORDER BY LINE.ID,RUL.major_version;

Line 2964: INSERT INTO OKS_K_LINES_BH

2960: l_tabsize := i_clev_tbl_in.COUNT;
2961: -- dbms_output.put_line('Value of l_tabsize='||TO_CHAR(l_tabsize));
2962: FORALL I IN 1 .. l_tabsize
2963:
2964: INSERT INTO OKS_K_LINES_BH
2965: (
2966: ID,
2967: MAJOR_VERSION ,
2968: CLE_ID,

Line 3298: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_Lines_BH where cle_id = LINE.ID)

3294: AND RUL.RULE_INFORMATION_CATEGORY IN ('OFS','CVR','DST','PRE','BTD')
3295: AND LINE.DNZ_CHR_ID = RGP.DNZ_CHR_ID
3296: -- AND RUL.RULE_INFORMATION15 IS NULL
3297: AND Rul.rowid BETWEEN l_start_rowid and l_end_rowid
3298: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_Lines_BH where cle_id = LINE.ID)
3299: AND LINE.MAJOR_VERSION = RGP.MAJOR_VERSION
3300: AND RGP.MAJOR_VERSION = RUL.MAJOR_VERSION
3301: ORDER BY LINE.ID,RUL.MAJOR_VERSION;
3302:

Line 4333: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_BH WHERE CLE_ID = LINE.ID)

4329: AND RGP.MAJOR_VERSION = RUL.MAJOR_VERSION
4330: AND LINE.MAJOR_VERSION = RGP.MAJOR_VERSION
4331: -- AND RUL.RULE_INFORMATION15 IS NULL
4332: AND Rul.rowid BETWEEN l_start_rowid and l_end_rowid
4333: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_BH WHERE CLE_ID = LINE.ID)
4334: ORDER BY LINE.ID;
4335:
4336: CURSOR Get_Rule_TlH (P_ID IN NUMBER) IS
4337: SELECT ID,

Line 5069: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_BH WHERE CLE_ID = LINE.ID)

5065: --AND RUL.RULE_INFORMATION_CATEGORY IN ('LMT')
5066: AND Rul.rowid BETWEEN l_start_rowid and l_end_rowid
5067: AND RGP.MAJOR_VERSION = LINE.MAJOR_VERSION
5068: AND RGP.MAJOR_VERSION = RUL.MAJOR_VERSION
5069: AND NOT EXISTS (SELECT CLE_ID FROM OKS_K_LINES_BH WHERE CLE_ID = LINE.ID)
5070: ORDER BY LINE.ID;
5071:
5072: CURSOR Get_Rule_TlH (P_ID IN NUMBER) IS
5073: SELECT ID,