DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_RG_PARTY_ROLES_V

Line 2832: FROM okc_rg_party_roles_v

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

Line 2838: FROM okc_rg_party_roles_v rgp, okc_rg_role_defs rrd

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