285: /* Added this select for Fin plan Impact */
286: BEGIN
287: SELECT 'x'
288: INTO dummy
289: FROM dual
290: WHERE EXISTS( SELECT *
291: FROM pa_fin_plan_types_b f
292: WHERE f.fin_plan_type_id=l_cost_plan_type_id );
293:
317: /* Added this select for Fin plan Impact */
318: BEGIN
319: SELECT 'x'
320: INTO dummy
321: FROM dual
322: WHERE EXISTS( SELECT *
323: FROM pa_fin_plan_types_b f
324: WHERE f.fin_plan_type_id=l_rev_plan_type_id );
325: