APPS.OKC_SCN_PVT dependencies on OKC_SECTIONS_BH

Line 578: FROM OKC_SECTIONS_BH B

574: );
575: DELETE FROM OKC_SECTIONS_TLH T
576: WHERE NOT EXISTS (
577: SELECT NULL
578: FROM OKC_SECTIONS_BH B
579: WHERE B.ID = T.ID
580: AND B.MAJOR_VERSION = T.MAJOR_VERSION
581: );
582:

Line 4144: INSERT INTO okc_sections_bh

4140: okc_debug.Set_Indentation('OKC_SCN_PVT');
4141: okc_debug.log('14900: Entered create_version', 2);
4142: END IF;
4143:
4144: INSERT INTO okc_sections_bh
4145: (
4146: major_version,
4147: id,
4148: scn_type,

Line 4321: FROM okc_sections_bh

4317: last_update_date,
4318: last_update_login
4319: FROM okc_sections_tlh
4320: WHERE id in (SELECT id
4321: FROM okc_sections_bh
4322: WHERE chr_id = p_chr_id)
4323: AND major_version = p_major_version;
4324:
4325: -----------------------------

Line 4391: FROM okc_sections_bh

4387: attribute12,
4388: attribute13,
4389: attribute14,
4390: attribute15
4391: FROM okc_sections_bh
4392: WHERE chr_id = p_chr_id
4393: AND major_version = p_major_version;
4394:
4395: IF (l_debug = 'Y') THEN