DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_RULES_V

Line 170: -- From okc_rules_v rul

166:
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

Line 180: from okc_rules_v

176:
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:

Line 213: From okc_rules_v rul

209: Is
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

Line 4528: From okc_rules_v rul

4524: Is
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

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;