APPS.OKC_XPRT_RULES_ENGINE_PVT dependencies on OKC_TERMS_TEMPLATES_ALL

Line 84: WHERE rule.org_id = (SELECT org_id FROM okc_terms_templates_all WHERE template_id = p_template_id)

80: AND rule.rule_id = rultmpl.rule_id
81: UNION ALL
82: SELECT rule.rule_id, rule.condition_expr_code
83: FROM okc_xprt_rule_hdrs_all_v rule
84: WHERE rule.org_id = (SELECT org_id FROM okc_terms_templates_all WHERE template_id = p_template_id)
85: AND rule.intent = (SELECT intent FROM okc_terms_templates_all WHERE template_id = p_template_id)
86: AND rule.org_wide_flag = 'Y';
87:
88: CURSOR c_rule_conditions IS

Line 85: AND rule.intent = (SELECT intent FROM okc_terms_templates_all WHERE template_id = p_template_id)

81: UNION ALL
82: SELECT rule.rule_id, rule.condition_expr_code
83: FROM okc_xprt_rule_hdrs_all_v rule
84: WHERE rule.org_id = (SELECT org_id FROM okc_terms_templates_all WHERE template_id = p_template_id)
85: AND rule.intent = (SELECT intent FROM okc_terms_templates_all WHERE template_id = p_template_id)
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

Line 97: WHERE rule.org_id = (SELECT org_id FROM okc_terms_templates_all WHERE template_id = p_template_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;
101:

Line 98: AND rule.intent = (SELECT intent FROM okc_terms_templates_all WHERE template_id = p_template_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;
101:
102: rule_ids number_type;