APPS.OKC_XPRT_RULES_ENGINE_PVT dependencies on OKC_XPRT_RULE_COND_ACTIVE_V

Line 90: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_hdrs_all_v rule, okc_xprt_rule_cond_active_v cond

86: AND rule.org_wide_flag = 'Y';
87:
88: CURSOR c_rule_conditions IS
89: SELECT cond.rule_id, cond.rule_condition_id, cond.object_type condition_type, cond.object_code, rule.condition_expr_code, cond.object_value_type, cond.object_value_code, cond.operator
90: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_hdrs_all_v rule, okc_xprt_rule_cond_active_v cond
91: WHERE rultmpl.template_id = p_template_id
92: AND rule.rule_id = rultmpl.rule_id
93: AND cond.rule_id = rule.rule_id
94: UNION ALL

Line 96: FROM okc_xprt_rule_hdrs_all_v rule, okc_xprt_rule_cond_active_v cond

92: AND rule.rule_id = rultmpl.rule_id
93: AND cond.rule_id = rule.rule_id
94: UNION ALL
95: SELECT cond.rule_id, cond.rule_condition_id, cond.object_type condition_type, cond.object_code, rule.condition_expr_code, cond.object_value_type, cond.object_value_code, cond.operator
96: FROM okc_xprt_rule_hdrs_all_v rule, okc_xprt_rule_cond_active_v cond
97: WHERE rule.org_id = (SELECT org_id FROM okc_terms_templates_all WHERE template_id = p_template_id)
98: AND rule.intent = (SELECT intent FROM okc_terms_templates_all WHERE template_id = p_template_id)
99: AND rule.org_wide_flag = 'Y'
100: AND cond.rule_id = rule.rule_id;