Line 1447: exists ( select 1 from pa_options where parent_option_code = p_option_code);
1443: begin
1444: select 1
1445: into temp
1446: from sys.dual where 1447: exists ( select 1 from pa_options where parent_option_code = p_option_code); 1448: rv := 'Y';
1449: exception
1450: when NO_DATA_FOUND then
1451: rv := 'N';