DBA Data[Home] [Help]

APPS.OKC_CLM_PKG dependencies on OKC_XPRT_TEMPLATE_RULES

Line 440: okc_xprt_template_rules trule

436: (SELECT distinct rcon.object_code variable_code -- LHS 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

Line 455: okc_xprt_template_rules trule

451: SELECT distinct rcon.object_value_code variable_code -- RHS of Condition from Template rule
452: FROM okc_xprt_rule_hdrs_all rhdr,
453: okc_xprt_rule_conditions rcon,
454: okc_template_usages tuse,
455: okc_xprt_template_rules trule
456: WHERE tuse.document_id = p_doc_id
457: AND tuse.document_type = p_doc_type
458: AND tuse.template_id = trule.template_id
459: AND trule.rule_id = rhdr.rule_id