108: ) child_req_id,
109: SUBSTR(req_data,
110: INSTR(req_data,':',1) + 1
111: ) run_id
112: FROM dual;
113:
114: CURSOR csr_cz_imp_rules_cnt IS
115: SELECT COUNT(*)
116: FROM cz_imp_rules
982: ) child_req_id,
983: SUBSTR(req_data,
984: INSTR(req_data,':',1) + 1
985: ) run_id
986: FROM dual;
987:
988: CURSOR csr_cz_imp_rules_cnt IS
989: SELECT COUNT(*)
990: FROM cz_imp_rules
1890: ) child_req_id,
1891: SUBSTR(req_data,
1892: INSTR(req_data,':',1) + 1
1893: ) run_id
1894: FROM dual;
1895:
1896: CURSOR csr_cz_imp_rules_cnt IS
1897: SELECT COUNT(*)
1898: FROM cz_imp_rules