APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on CZ_RULES

Line 1281: FROM cz_rules

1277: -- Changed for R12
1278: SELECT SUBSTR(orig_sys_ref, INSTR(orig_sys_ref,':',-1,3)+1,
1279: (INSTR(orig_sys_ref,':',-1,2) - (INSTR(orig_sys_ref,':',-1,3)+1))
1280: )
1281: FROM cz_rules
1282: WHERE SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1) = to_char(p_rule_id)
1283: AND rule_type = 200 -- Added for Bug 5005681
1284: AND rule_id = persistent_rule_id
1285: AND deleted_flag = '0'

Line 1498: FROM cz_rules

1494: -- Updated the substr for bug 4676800
1495: SELECT SUBSTR(orig_sys_ref, INSTR(orig_sys_ref,':',-1,3)+1,
1496: (INSTR(orig_sys_ref,':',-1,2) - (INSTR(orig_sys_ref,':',-1,3)+1))
1497: )
1498: FROM cz_rules
1499: WHERE SUBSTR(orig_sys_ref,INSTR(orig_sys_ref,':',-1,1)+1) = to_char(p_rule_id)
1500: AND rule_id = persistent_rule_id
1501: AND deleted_flag = '0'
1502: AND rule_type = 200; --Added for perf Bug#5032335

Line 1891: FROM cz_rules

1887: AND deleted_flag = 0;
1888:
1889: CURSOR csr_check_ext_rule (p_devl_project_id NUMBER) IS
1890: SELECT 'X'
1891: FROM cz_rules
1892: WHERE rule_type = 300 -- Extension rule
1893: AND devl_project_id = p_devl_project_id
1894: AND rule_id = persistent_rule_id
1895: AND deleted_flag = 0;