APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on CZ_RULES

Line 1267: FROM cz_rules

1263: -- Changed for R12
1264: SELECT SUBSTR(orig_sys_ref, INSTR(orig_sys_ref,':',-1,3)+1,
1265: (INSTR(orig_sys_ref,':',-1,2) - (INSTR(orig_sys_ref,':',-1,3)+1))
1266: )
1267: FROM cz_rules
1268: WHERE SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1) = to_char(p_rule_id)
1269: AND rule_type = 200 -- Added for Bug 5005681
1270: AND rule_id = persistent_rule_id
1271: AND deleted_flag = '0'

Line 1484: FROM cz_rules

1480: -- Updated the substr for bug 4676800
1481: SELECT SUBSTR(orig_sys_ref, INSTR(orig_sys_ref,':',-1,3)+1,
1482: (INSTR(orig_sys_ref,':',-1,2) - (INSTR(orig_sys_ref,':',-1,3)+1))
1483: )
1484: FROM cz_rules
1485: WHERE SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1) = to_char(p_rule_id)
1486: AND rule_id = persistent_rule_id
1487: AND deleted_flag = '0'
1488: AND rule_type = 200; --Added for perf Bug#5032335

Line 1877: FROM cz_rules

1873: AND deleted_flag = 0;
1874:
1875: CURSOR csr_check_ext_rule (p_devl_project_id NUMBER) IS
1876: SELECT 'X'
1877: FROM cz_rules
1878: WHERE rule_type = 300 -- Extension rule
1879: AND devl_project_id = p_devl_project_id
1880: AND rule_id = persistent_rule_id
1881: AND deleted_flag = 0;