APPS.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on OKC_RULES_V

Line 1260: l_rul_id okc_rules_v.id%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;
1264:

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