[Home] [Help]
103: SELECT 'x'
104: INTO dummy
105: FROM dual
106: WHERE EXISTS( SELECT *
107: FROM pa_fin_plan_types_b f
108: WHERE f.fin_plan_type_id=l_cost_plan_type_id );
109:
110: EXCEPTION
111: WHEN NO_DATA_FOUND THEN
136: SELECT 'x'
137: INTO dummy
138: FROM dual
139: WHERE EXISTS( SELECT *
140: FROM pa_fin_plan_types_b f
141: WHERE f.fin_plan_type_id=l_rev_plan_type_id );
142:
143: EXCEPTION
144: WHEN NO_DATA_FOUND THEN