APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_RULE_GROUPS_V

Line 171: -- ,okc_rule_groups_v rgp

167:
168: -- Cursor Get_Rule_objectid_Csr Is
169: -- Select object1_id1
170: -- From okc_rules_v rul
171: -- ,okc_rule_groups_v rgp
172: -- Where rul.rgp_id = rgp.id
173: -- And rule_information_category = p_category
174: -- And jtot_object1_Code = p_object_Code
175: -- And cle_id = p_cle_id;

Line 181: where rgp_id = (select id from okc_rule_groups_v where cle_id = p_cle_id)

177: -- Fixed Bug# 2281008
178: Cursor Get_Rule_objectid_Csr Is
179: Select object1_id1
180: from okc_rules_v
181: where rgp_id = (select id from okc_rule_groups_v where cle_id = p_cle_id)
182: And rule_information_category = p_category;
183:
184:
185:

Line 214: ,okc_rule_groups_v rgp

210:
211: Cursor Get_Rule_objectid_Csr Is
212: Select object1_id1
213: From okc_rules_v rul
214: ,okc_rule_groups_v rgp
215: Where rul.rgp_id = rgp.id
216: And rule_information_category = p_category
217: And jtot_object1_Code = p_object_Code
218: And rgp.dnz_chr_id = p_chr_id

Line 4529: ,okc_rule_groups_v rgp

4525:
4526: Cursor Get_Rule_objectid_Csr Is
4527: Select object1_id1
4528: From okc_rules_v rul
4529: ,okc_rule_groups_v rgp
4530: Where rul.rgp_id = rgp.id
4531: And rule_information_category = p_category
4532: And jtot_object1_Code = p_object_Code
4533: And rgp.dnz_chr_id = p_chr_id

Line 4560: FROM okc_rules_v rul, okc_rule_groups_v rgp

4556: IS
4557: CURSOR get_rule_objectid_csr
4558: IS
4559: SELECT object1_id1
4560: FROM okc_rules_v rul, okc_rule_groups_v rgp
4561: WHERE rul.rgp_id = rgp.ID
4562: AND rule_information_category = p_category
4563: AND jtot_object1_code = p_object_code
4564: AND cle_id = p_cle_id;