APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_RG_PARTY_ROLES_V

Line 2833: FROM okc_rg_party_roles_v

2829: --->No union
2830:
2831: CURSOR c_rmpv(p_rgp_id IN NUMBER) IS
2832: SELECT rrd_id,cpl_id
2833: FROM okc_rg_party_roles_v
2834: WHERE rgp_id = p_rgp_id;
2835: --->Union Yes
2836:
2837: CURSOR c_rrdv(p_rgp_id IN NUMBER) IS

Line 2839: FROM okc_rg_party_roles_v rgp, okc_rg_role_defs rrd

2835: --->Union Yes
2836:
2837: CURSOR c_rrdv(p_rgp_id IN NUMBER) IS
2838: SELECT cpl_id
2839: FROM okc_rg_party_roles_v rgp, okc_rg_role_defs rrd
2840: WHERE rrd.id = rgp.rrd_id
2841: and rgp.dnz_chr_id = (select dnz_chr_id
2842: from okc_rule_groups_b
2843: where id = p_rgp_id)