APPS.OKC_QA_DATA_INTEGRITY dependencies on OKC_K_PARTY_ROLES_B

Line 221: OKC_K_PARTY_ROLES_B cpl

217: CURSOR l_cpl1_csr IS
218: SELECT cpl.ID, cpl.JTOT_OBJECT1_CODE, cpl.OBJECT1_ID1, cpl.OBJECT1_ID2,
219: fnd.MEANING, cpl.rle_code, cpl.chr_id, cpl.cle_id
220: FROM FND_LOOKUPS fnd,
221: OKC_K_PARTY_ROLES_B cpl
222: WHERE fnd.LOOKUP_CODE = cpl.rle_code
223: AND fnd.LOOKUP_TYPE = 'OKC_ROLE'
224: AND cpl.dnz_chr_id = p_chr_id;
225: l_cpl1_rec l_cpl1_csr%ROWTYPE;

Line 230: FROM OKC_K_PARTY_ROLES_B cpl

226:
227: -- Do not use chr_id in the where clause, this column is not indexed.
228: CURSOR l_cpl_csr IS
229: SELECT count(distinct RLE_CODE)
230: FROM OKC_K_PARTY_ROLES_B cpl
231: WHERE cpl.dnz_chr_id = p_chr_id
232: AND cpl.cle_id is NULL;
233:
234:

Line 251: FROM OKC_K_PARTY_ROLES_B

247: l_cle_rec l_cle_csr%ROWTYPE;
248:
249: CURSOR l_chr_csr IS
250: SELECT 'x'
251: FROM OKC_K_PARTY_ROLES_B
252: WHERE dnz_chr_id = p_chr_id
253: AND chr_id = p_chr_id
254: AND rle_code = l_cpl1_rec.rle_code
255: AND jtot_object1_code = l_cpl1_rec.jtot_object1_code

Line 1407: CURSOR l_kpr_csr(p_id OKC_K_PARTY_ROLES_B.ID%TYPE) IS

1403: -- WHERE (rpr.cpl_id IS NOT NULL or l_template_yn = 'Y')
1404:
1405: l_cpl_id OKC_RG_PARTY_ROLES.CPL_ID%TYPE;
1406:
1407: CURSOR l_kpr_csr(p_id OKC_K_PARTY_ROLES_B.ID%TYPE) IS
1408: SELECT kpr.rle_code, fl.meaning
1409: FROM OKC_K_PARTY_ROLES_B kpr,
1410: FND_LOOKUPS fl
1411: WHERE kpr.id = p_id

Line 1409: FROM OKC_K_PARTY_ROLES_B kpr,

1405: l_cpl_id OKC_RG_PARTY_ROLES.CPL_ID%TYPE;
1406:
1407: CURSOR l_kpr_csr(p_id OKC_K_PARTY_ROLES_B.ID%TYPE) IS
1408: SELECT kpr.rle_code, fl.meaning
1409: FROM OKC_K_PARTY_ROLES_B kpr,
1410: FND_LOOKUPS fl
1411: WHERE kpr.id = p_id
1412: AND fl.lookup_type = 'OKC_ROLE'
1413: AND fl.lookup_code = kpr.rle_code;