[Home] [Help]
646: into p_del_flag
647: from sys.dual
648: where exists (
649: select null
650: from per_assignment_budget_values_f
651: where assignment_id = p_assignment_id
652: and p_delete_mode = 'ZAP');
653:
654: EXCEPTION
657: --
658: IF p_del_flag = 'Y' and
659: p_delete_mode = 'ZAP' THEN
660:
661: Delete per_assignment_budget_values_f
662: where assignment_id = p_assignment_id;
663:
664: END IF;
665: --