2986: ELSE
2987: BEGIN
2988: SELECT ext_fld_id
2989: INTO l_ext_field_id 2990: FROM ben_ext_fld 2991: WHERE short_name = p_field_short_name;
2992: EXCEPTION
2993: WHEN NO_DATA_FOUND THEN
2994: RAISE;
Line 4623: from ben_ext_fld
4619: l_new_business_group_id number ;
4620:
4621: cursor c_1 (p_ext_fld_id number ) is
4622: select decd_flag 4623: from ben_ext_fld 4624: where ext_fld_id = p_ext_fld_id ;
4625:
4626: begin
4627: