350: IS
351: cursor getrt(p_business_group_id number)
352: is
353: select run_type_id
354: from pay_run_types_f
355: where business_group_id = p_business_group_id;
356: BEGIN
357: --
358: for rtrec in getrt (p_business_group_id) loop
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
367: where run_type_id = rtrec.run_type_id;
368: delete from pay_run_types_f
369: where run_type_id = rtrec.run_type_id;
370: --
371: end loop;
372: --