APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_RULE_GROUPS_B

Line 2824: FROM okc_rules_b rul, okc_rule_groups_b rgp ,okc_rg_def_rules rgdef

2820: --to be copied is also available in the rules setup i.e
2821: --in okc_rg_def_rules table
2822: CURSOR c_rulv(p_rgp_id IN NUMBER) IS
2823: SELECT rul.id,rule_information_category
2824: FROM okc_rules_b rul, okc_rule_groups_b rgp ,okc_rg_def_rules rgdef
2825: WHERE rul.rgp_id = p_rgp_id
2826: and rul.rgp_id=rgp.id
2827: and rgp.rgd_code=rgdef.rgd_code
2828: and rul.rule_information_category=rgdef.rdf_code;

Line 2842: from okc_rule_groups_b

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)
2844: and rgp.rgp_id = p_rgp_id
2845: and rrd.subject_object_flag = 'O';
2846: ---No Union REQD

Line 2852: okc_rule_groups_b rgp,

2848: --Bug 3948599
2849: CURSOR c_rgdv_csr(p_rgp_id IN NUMBER,p_dnz_chr_id IN NUMBER) IS
2850: SELECT 'x'
2851: FROM FND_LOOKUP_VALUES rgdv,
2852: okc_rule_groups_b rgp,
2853: OKC_SUBCLASS_RG_DEFS srdv,
2854: OKC_K_HEADERS_B chrv
2855: WHERE rgp.id = p_rgp_id
2856: AND rgdv.LOOKUP_CODE = rgp.rgd_code

Line 3666: FROM okc_rule_groups_b

3662: WHERE id = p_to_cle_id;
3663:
3664: CURSOR c_rgpv IS
3665: SELECT id
3666: FROM okc_rule_groups_b
3667: WHERE cle_id = p_from_cle_id;
3668:
3669: CURSOR c_catv IS
3670: SELECT id

Line 6078: FROM okc_rule_groups_b

6074: AND G_COPY_HISTORY_YN = 'Y';
6075: --------------------------------------------------
6076: CURSOR c_rgpv IS
6077: SELECT id
6078: FROM okc_rule_groups_b
6079: WHERE dnz_chr_id = p_chr_id
6080: AND cle_id is null
6081: AND g_copy_history_yn = 'N'
6082: UNION ALL

Line 6084: FROM okc_rule_groups_bH

6080: AND cle_id is null
6081: AND g_copy_history_yn = 'N'
6082: UNION ALL
6083: SELECT id
6084: FROM okc_rule_groups_bH
6085: WHERE dnz_chr_id = p_chr_id and cle_id is null
6086: AND major_version = G_FROM_VERSION_NUMBER
6087: AND G_COPY_HISTORY_YN = 'Y';
6088: ---------------------------------------------------