APPS.OKC_CPL_PVT dependencies on OKC_K_PARTY_ROLES_BH

Line 142: FROM OKC_K_PARTY_ROLES_BH B

138: /*
139: DELETE FROM OKC_K_PARTY_ROLES_TLH T
140: WHERE NOT EXISTS (
141: SELECT NULL
142: FROM OKC_K_PARTY_ROLES_BH B
143: WHERE B.ID = T.ID
144: AND B.MAJOR_VERSION = T.MAJOR_VERSION
145: );
146:

Line 5243: INSERT INTO okc_k_party_roles_bh

5239: okc_debug.Set_Indentation('OKC_CPL_PVT');
5240: okc_debug.log('16300: Entered create_version', 2);
5241: END IF;
5242:
5243: INSERT INTO okc_k_party_roles_bh
5244: (
5245: major_version,
5246: id,
5247: chr_id,

Line 5454: FROM okc_k_party_roles_bh

5450: alias,
5451: last_update_login
5452: FROM okc_k_party_roles_tlh
5453: WHERE id in (SELECT id
5454: FROM okc_k_party_roles_bh
5455: WHERE dnz_chr_id = p_chr_id)
5456: AND major_version = p_major_version;
5457:
5458: ----------------------------------------

Line 5554: FROM okc_k_party_roles_bh

5550: /* orig_system_id1,
5551: orig_system_reference1,
5552: orig_system_source_code */
5553: -- R12 Data Model Changes 4485150 End
5554: FROM okc_k_party_roles_bh
5555: WHERE dnz_chr_id = p_chr_id
5556: AND major_version = p_major_version;
5557:
5558: IF (l_debug = 'Y') THEN