1995: );
1996: DELETE FROM OKC_RULES_TLH T
1997: WHERE NOT EXISTS (
1998: SELECT NULL
1999: FROM OKC_RULES_BH B
2000: WHERE B.ID = T.ID
2001: AND B.MAJOR_VERSION = T.MAJOR_VERSION
2002: );
2003:
6055:
6056:
6057:
6058:
6059: INSERT INTO okc_rules_bh
6060: (
6061: major_version,
6062: id,
6063: rgp_id,
6289: last_update_date,
6290: last_update_login
6291: FROM okc_rules_tlh
6292: WHERE id in (SELECT id
6293: FROM okc_rules_bh
6294: WHERE dnz_chr_id = p_chr_id)
6295: AND major_version = p_major_version;
6296: */
6297: -----------------------------------------
6420: ans_set_jtot_object_id2,
6421: display_sequence,
6422: --Bug 3055393
6423: comments
6424: FROM okc_rules_bh
6425: WHERE dnz_chr_id = p_chr_id
6426: AND major_version = p_major_version;
6427:
6428: