APPS.OKC_XPRT_IMPORT_PVT dependencies on CZ_RULES

Line 44: FROM cz_rules

40: RETURN VARCHAR2 IS
41:
42: CURSOR csr_check_rule_exists (p_rule_id NUMBER) IS
43: SELECT 'X'
44: FROM cz_rules
45: WHERE rule_type = 200 -- Statement rule
46: --AND devl_project_id = p_devl_project_id
47: AND rule_id = persistent_rule_id
48: AND SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1) = to_char(p_rule_id) --For Bug# 8240959