APPS.OKC_XPRT_IMPORT_TEMPLATE_PVT dependencies on OKC_XPRT_TEMPLATE_RULES
Line 2916: okc_xprt_template_rules r,
2912: CURSOR csr_local_rules_templates IS
2913: -- Templates on Local Rules
2914: SELECT DISTINCT to_char(r.template_id)
2915: FROM okc_terms_templates_all t, 2916: okc_xprt_template_rules r, 2917: okc_xprt_rule_hdrs_all h
2918: WHERE r.template_id = t.template_id
2919: AND r.rule_id = h.rule_id
2920: AND t.status_code IN ('APPROVED','ON_HOLD')