442: -- should allow both cost impact and revenue impacts.
443: Begin
444: select 'Y'
445: into l_appr_bdgt_pt_exists
446: from dual
447: where exists
448: (select 1 from pa_proj_fp_options
449: where project_id = p_project_id
450: and approved_cost_plan_type_flag = 'Y'