[Home] [Help]
1932: return boolean is
1933:
1934: CURSOR occ_cur (tfr_id number,p_occ_series varchar2) IS
1935: select occ_code
1936: from ghr_mass_transfer_criteria
1937: where MASS_TRANSFER_ID = tfr_id
1938: and occ_code = p_occ_series;
1939:
1940: CURSOR occ_cur_cnt (tfr_id number) is
1938: and occ_code = p_occ_series;
1939:
1940: CURSOR occ_cur_cnt (tfr_id number) is
1941: select count(*) COUNT
1942: from ghr_mass_transfer_criteria
1943: where MASS_TRANSFER_ID = tfr_id;
1944:
1945: l_cnt number := 0;
1946: l_occ_code varchar2(30) := null;