APPS.OKC_QA_DATA_INTEGRITY dependencies on OKC_RG_PARTY_ROLES

Line 1400: FROM OKC_RG_PARTY_ROLES rpr

1396: l_rrd_rec l_rrd_csr%ROWTYPE;
1397:
1398: CURSOR l_rpr_csr IS
1399: SELECT rpr.cpl_id
1400: FROM OKC_RG_PARTY_ROLES rpr
1401: WHERE rpr.rgp_id = l_rrd_rec.rgp_id
1402: AND rpr.rrd_id = l_rrd_rec.rrd_id;
1403: -- WHERE (rpr.cpl_id IS NOT NULL or l_template_yn = 'Y')
1404:

Line 1405: l_cpl_id OKC_RG_PARTY_ROLES.CPL_ID%TYPE;

1401: WHERE rpr.rgp_id = l_rrd_rec.rgp_id
1402: AND rpr.rrd_id = l_rrd_rec.rrd_id;
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,