APPS.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on OKC_RG_PARTY_ROLES_V

Line 1258: l_id okc_rg_party_roles_v.id%type;

1254: l_k_vendor_id1 okc_k_party_roles_v.object1_id1%type;
1255: l_rle_code okc_k_party_roles_v.rle_code%type;
1256: l_id1 okx_vendor_sites_v.vendor_id%type;
1257:
1258: l_id okc_rg_party_roles_v.id%type;
1259: l_rgp_id okc_rg_party_roles_v.rgp_id%type;
1260: l_rul_id okc_rules_v.id%type;
1261:
1262: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

Line 1259: l_rgp_id okc_rg_party_roles_v.rgp_id%type;

1255: l_rle_code okc_k_party_roles_v.rle_code%type;
1256: l_id1 okx_vendor_sites_v.vendor_id%type;
1257:
1258: l_id okc_rg_party_roles_v.id%type;
1259: l_rgp_id okc_rg_party_roles_v.rgp_id%type;
1260: l_rul_id okc_rules_v.id%type;
1261:
1262: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
1263: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

Line 1304: from okc_rg_party_roles_v rgpr, okc_rule_groups_v rgp

1300: --end modified abhsaxen for performance SQLID 20562568
1301: ;
1302: cursor l_rg_party_csr is
1303: select rgpr.id ,rgpr.rgp_id
1304: from okc_rg_party_roles_v rgpr, okc_rule_groups_v rgp
1305: where rgpr.dnz_chr_id = p_chr_id
1306: and rgpr.cpl_id = p_cpl_id
1307: and rgpr.dnz_chr_id = rgp.dnz_chr_id
1308: and rgpr.dnz_chr_id = rgp.chr_id

Line 1313: from okc_rg_party_roles_v rgpr, okc_rule_groups_v rgp, okc_rules_v rul

1309: and rgpr.rgp_id = rgp.id;
1310:
1311: cursor l_r_party_csr is
1312: select rul.id
1313: from okc_rg_party_roles_v rgpr, okc_rule_groups_v rgp, okc_rules_v rul
1314: where rgpr.dnz_chr_id = p_chr_id
1315: and rgpr.cpl_id = p_cpl_id
1316: and rgpr.dnz_chr_id = rgp.dnz_chr_id
1317: and rgpr.dnz_chr_id = rgp.chr_id