APPS.HR_DELETE dependencies on PER_TIME_PERIODS

Line 299: delete from per_time_periods

295: BEGIN
296: --
297: for timrec in get_time_defs(p_business_group_id) loop
298: --
299: delete from per_time_periods
300: where time_definition_id = timrec.time_definition_id;
301: --
302: end loop;
303: --

Line 1670: DELETE FROM PER_TIME_PERIODS tim

1666: WHERE ase.business_group_id = p_business_group_id;
1667: hr_utility.set_location(l_proc,50);
1668: --
1669: --
1670: DELETE FROM PER_TIME_PERIODS tim
1671: WHERE EXISTS ( SELECT ''
1672: FROM pay_payrolls_f pp
1673: WHERE pp.payroll_id = tim.payroll_id
1674: AND pp.business_group_id = p_business_group_id);