DBA Data[Home] [Help]

APPS.OKC_CLM_PKG dependencies on OKC_XPRT_RULE_CONDITIONS

Line 438: okc_xprt_rule_conditions rcon,

434: AND var.variable_source = 'M'
435: AND var.variable_code IN
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

Line 453: okc_xprt_rule_conditions rcon,

449: GROUP BY rcon.object_code
450: UNION
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

Line 468: okc_xprt_rule_conditions rcon

464: GROUP BY rcon.object_value_code
465: UNION
466: SELECT distinct rcon.object_code variable_code -- LHS of Condition from Global Rule
467: FROM okc_xprt_rule_hdrs_all rhdr,
468: okc_xprt_rule_conditions rcon
469: WHERE rhdr.rule_id = rcon.rule_id
470: AND rhdr.org_id = p_org_id
471: AND rhdr.intent = p_intent
472: AND rhdr.org_wide_flag = 'Y'

Line 480: okc_xprt_rule_conditions rcon

476: GROUP BY rcon.object_code
477: UNION
478: SELECT distinct rcon.object_value_code variable_code -- RHS of Condition from Global Rule
479: FROM okc_xprt_rule_hdrs_all rhdr,
480: okc_xprt_rule_conditions rcon
481: WHERE rhdr.rule_id = rcon.rule_id
482: AND rhdr.org_id = p_org_id
483: AND rhdr.intent = p_intent
484: AND rhdr.org_wide_flag = 'Y'