APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_RULE_GROUPS_B

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

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

Line 2841: from okc_rule_groups_b

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

Line 2851: okc_rule_groups_b rgp,

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

Line 3665: FROM okc_rule_groups_b

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

Line 6077: FROM okc_rule_groups_b

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

Line 6083: FROM okc_rule_groups_bH

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