345:
346: DELETE FROM psb_default_assignments
347: WHERE default_rule_id = p_default_rule_id;
348:
349: DELETE FROM psb_default_account_distrs
350: WHERE default_rule_id = p_default_rule_id;
351:
352: -- Check the existence of Non FTE record.
353: DELETE FROM psb_defaults
379:
380: DELETE FROM psb_default_assignments
381: WHERE default_rule_id = p_default_rule_id;
382:
383: DELETE FROM psb_default_account_distrs
384: WHERE default_rule_id = p_default_rule_id;
385:
386: DELETE FROM psb_defaults
387: WHERE default_rule_id = p_default_rule_id;