APPS.HR_DELETE dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 1299: per_absence_attendance_types.business_group_id%TYPE)

1295: WHERE business_group_id = c_business_group_id;
1296: --
1297: cursor csr_get_aats
1298: (c_business_group_id
1299: per_absence_attendance_types.business_group_id%TYPE)
1300: is
1301: SELECT null
1302: FROM per_absence_attendance_types
1303: WHERE business_group_id = c_business_group_id;

Line 1302: FROM per_absence_attendance_types

1298: (c_business_group_id
1299: per_absence_attendance_types.business_group_id%TYPE)
1300: is
1301: SELECT null
1302: FROM per_absence_attendance_types
1303: WHERE business_group_id = c_business_group_id;
1304: --
1305: begin
1306: hr_utility.set_location('Entering: '||l_proc,10);

Line 1326: from per_absence_attendance_types b

1322: --
1323: DELETE FROM per_abs_attendance_types_tl t
1324: WHERE t.absence_attendance_type_id in
1325: (select b.absence_attendance_type_id
1326: from per_absence_attendance_types b
1327: where b.business_group_id = p_business_group_id);
1328: hr_utility.set_location(l_proc,40);
1329: --
1330: DELETE FROM per_absence_attendance_types

Line 1330: DELETE FROM per_absence_attendance_types

1326: from per_absence_attendance_types b
1327: where b.business_group_id = p_business_group_id);
1328: hr_utility.set_location(l_proc,40);
1329: --
1330: DELETE FROM per_absence_attendance_types
1331: WHERE business_group_id = p_business_group_id;
1332: hr_utility.set_location(l_proc,40);
1333: --
1334: end if;