196: cursor template_line_rule_csr (p_doc_id number, p_doc_type varchar2) is
197: select 'X'
198: from okc_xprt_rule_hdrs_all rhdr,
199: okc_template_usages tuse,
200: okc_xprt_template_rules trule
201: where tuse.document_id = p_doc_id
202: and tuse.document_type = p_doc_type
203: and tuse.template_id = trule.template_id
204: and trule.rule_id = rhdr.rule_id
421: AND var.variable_code IN ( SELECT rcon.object_code variable_code -- LHS of Condition from Template rule
422: FROM okc_xprt_rule_hdrs_all rhdr,
423: okc_xprt_rule_conditions rcon,
424: okc_template_usages tuse,
425: okc_xprt_template_rules trule
426: WHERE tuse.document_id = p_doc_id
427: AND tuse.document_type = p_doc_type
428: AND tuse.template_id = trule.template_id
429: AND trule.rule_id = rhdr.rule_id
436: SELECT rcon.object_value_code variable_code -- RHS of Condition from Template rule
437: FROM okc_xprt_rule_hdrs_all rhdr,
438: okc_xprt_rule_conditions rcon,
439: okc_template_usages tuse,
440: okc_xprt_template_rules trule
441: WHERE tuse.document_id = p_doc_id
442: AND tuse.document_type = p_doc_type
443: AND tuse.template_id = trule.template_id
444: AND trule.rule_id = rhdr.rule_id
682: (SELECT distinct rcon.object_code variable_code -- LHS of Condition from Template rule
683: FROM okc_xprt_rule_hdrs_all rhdr,
684: okc_xprt_rule_conditions rcon,
685: okc_template_usages tuse,
686: okc_xprt_template_rules trule
687: WHERE tuse.document_id = p_doc_id
688: AND tuse.document_type = p_doc_type
689: AND tuse.template_id = trule.template_id
690: AND trule.rule_id = rhdr.rule_id
697: SELECT distinct rcon.object_value_code variable_code -- RHS of Condition from Template rule
698: FROM okc_xprt_rule_hdrs_all rhdr,
699: okc_xprt_rule_conditions rcon,
700: okc_template_usages tuse,
701: okc_xprt_template_rules trule
702: WHERE tuse.document_id = p_doc_id
703: AND tuse.document_type = p_doc_type
704: AND tuse.template_id = trule.template_id
705: AND trule.rule_id = rhdr.rule_id