DBA Data[Home] [Help]

APPS.OKC_XPRT_TMPL_RULE_ASSNS_PVT dependencies on OKC_XPRT_RULE_HDRS_ALL

Line 49: okc_xprt_rule_hdrs_all r

45: -- get all rules on source template that are Not Inactive
46: CURSOR csr_template_rules IS
47: SELECT t.rule_id
48: FROM okc_xprt_template_rules t,
49: okc_xprt_rule_hdrs_all r
50: WHERE r.rule_id = t.rule_id
51: AND r.status_code <> 'INACTIVE'
52: AND NVL(t.deleted_flag,'N') <> 'Y'
53: AND t.template_id = p_source_template_id;