3050: END;
3051:
3052: if l_route_id <> stu_rec.route_id then
3053:
3054: delete ff_compiled_info_f
3055: where formula_id in (
3056: select fdi.formula_id
3057: from ff_fdi_usages_f fdi,
3058: ff_user_entities ue,
3349:
3350: if (l_route_id <> stu_rec.ROUTE_ID or
3351: l_run_dimension_id <> stu_rec.RUN_DIMENSION_ID) then
3352:
3353: delete ff_compiled_info_f fci
3354: where fci.formula_id in (
3355: select fdi.formula_id
3356: from ff_fdi_usages_f fdi
3357: where FDI.usage = 'D'