3935: begin
3936: SELECT substrb(profile_option_value,1,1)
3937: INTO eco_rev_warning_flag
3938: FROM fnd_profile_options opt,
3939: fnd_application appl,
3940: fnd_profile_option_values val
3941: WHERE opt.application_id = val.application_id
3942: AND opt.profile_option_id = val.profile_option_id
3943: AND opt.application_id = appl.application_id
4623: begin
4624: SELECT substrb(profile_option_value,1,1)
4625: INTO eco_rev_warning_flag
4626: FROM fnd_profile_options opt,
4627: fnd_application appl,
4628: fnd_profile_option_values val
4629: WHERE opt.application_id = val.application_id
4630: AND opt.profile_option_id = val.profile_option_id
4631: AND opt.application_id = appl.application_id