27:
28: CURSOR c_dfn (cp_ext_dfn_id NUMBER)
29: IS
30: SELECT DISTINCT (bed.name)
31: FROM ben_ext_dfn bed
32: WHERE bed.ext_dfn_id=cp_ext_dfn_id;
33:
34: CURSOR c_get_rec_cnt(cp_rslt_id NUMBER
35: ,cp_dfn_id NUMBER
36: )
37: IS
38: SELECT count(rslt.ext_rslt_id) rec_cnt
39: FROM ben_ext_rcd_in_file rin
40: ,ben_ext_dfn dfn
41: ,ben_ext_rslt_dtl rslt
42: WHERE dfn.ext_dfn_id = cp_dfn_id
43: AND rin.ext_file_id = dfn.ext_file_id
44: AND rin.hide_flag = 'N'