356: BEGIN
357: --
358: for rtrec in getrt (p_business_group_id) loop
359: --
360: delete from pay_run_type_usages_f
361: where parent_run_type_id = rtrec.run_type_id;
362: delete from pay_run_type_usages_f
363: where child_run_type_id = rtrec.run_type_id;
364: delete from pay_element_type_usages_f
358: for rtrec in getrt (p_business_group_id) loop
359: --
360: delete from pay_run_type_usages_f
361: where parent_run_type_id = rtrec.run_type_id;
362: delete from pay_run_type_usages_f
363: where child_run_type_id = rtrec.run_type_id;
364: delete from pay_element_type_usages_f
365: where run_type_id = rtrec.run_type_id;
366: delete from pay_run_type_org_methods_f