APPS.OKC_CPL_PVT dependencies on OKC_K_PARTY_ROLES_TLH

Line 139: DELETE FROM OKC_K_PARTY_ROLES_TLH T

135: AND t.id IS NULL;
136:
137: /* Commenting delete and update for bug 3723874 */
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

Line 147: UPDATE OKC_K_PARTY_ROLES_TLH T SET (

143: WHERE B.ID = T.ID
144: AND B.MAJOR_VERSION = T.MAJOR_VERSION
145: );
146:
147: UPDATE OKC_K_PARTY_ROLES_TLH T SET (
148: COGNOMEN,
149: ALIAS) = (SELECT
150: B.COGNOMEN,
151: B.ALIAS

Line 152: FROM OKC_K_PARTY_ROLES_TLH B

148: COGNOMEN,
149: ALIAS) = (SELECT
150: B.COGNOMEN,
151: B.ALIAS
152: FROM OKC_K_PARTY_ROLES_TLH B
153: WHERE B.ID = T.ID
154: AND B.MAJOR_VERSION = T.MAJOR_VERSION
155: AND B.LANGUAGE = T.SOURCE_LANG)
156: WHERE (

Line 164: FROM OKC_K_PARTY_ROLES_TLH SUBB, OKC_K_PARTY_ROLES_TLH SUBT

160: IN (SELECT
161: SUBT.ID,
162: SUBT.MAJOR_VERSION,
163: SUBT.LANGUAGE
164: FROM OKC_K_PARTY_ROLES_TLH SUBB, OKC_K_PARTY_ROLES_TLH SUBT
165: WHERE SUBB.ID = SUBT.ID
166: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
167: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
168: AND (SUBB.COGNOMEN <> SUBT.COGNOMEN

Line 178: INSERT /*+ append parallel(tt) */ INTO OKC_K_PARTY_ROLES_TLH tt(

174: ));
175: */
176: /* Modifying Insert as per performance guidelines given in bug 3723874 */
177:
178: INSERT /*+ append parallel(tt) */ INTO OKC_K_PARTY_ROLES_TLH tt(
179: ID,
180: LANGUAGE,
181: MAJOR_VERSION,
182: SOURCE_LANG,

Line 205: FROM OKC_K_PARTY_ROLES_TLH B, FND_LANGUAGES L

201: B.LAST_UPDATE_DATE,
202: B.COGNOMEN,
203: B.ALIAS,
204: B.LAST_UPDATE_LOGIN
205: FROM OKC_K_PARTY_ROLES_TLH B, FND_LANGUAGES L
206: WHERE L.INSTALLED_FLAG IN ('I', 'B')
207: AND B.LANGUAGE = USERENV('LANG')
208: ) v, OKC_K_PARTY_ROLES_TLH t
209: WHERE t.ID(+) = v.ID

Line 208: ) v, OKC_K_PARTY_ROLES_TLH t

204: B.LAST_UPDATE_LOGIN
205: FROM OKC_K_PARTY_ROLES_TLH B, FND_LANGUAGES L
206: WHERE L.INSTALLED_FLAG IN ('I', 'B')
207: AND B.LANGUAGE = USERENV('LANG')
208: ) v, OKC_K_PARTY_ROLES_TLH t
209: WHERE t.ID(+) = v.ID
210: AND t.MAJOR_VERSION(+) = v.MAJOR_VERSION
211: AND t.LANGUAGE(+) = v.LANGUAGE_CODE
212: AND t.id IS NULL;

Line 5345: INSERT INTO okc_k_party_roles_tlh

5341: --------------------------------
5342: -- Version TL Table
5343: --------------------------------
5344:
5345: INSERT INTO okc_k_party_roles_tlh
5346: (
5347: major_version,
5348: id,
5349: language,

Line 5452: FROM okc_k_party_roles_tlh

5448: last_update_date,
5449: cognomen,
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;