APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 379: from per_absence_attendances paa

375: -- absenses cursor
376: --
377: cursor absenses is
378: select rowid
379: from per_absence_attendances paa
380: where paa.business_group_id +0 = p_business_group_id
381: and paa.person_id = p_person_id
382: and paa.date_start >= p_primary_date
383: for update of person_id;

Line 1258: from per_absence_attendances paa

1254: -- absenses cursor
1255: --
1256: cursor absenses1 is
1257: select rowid
1258: from per_absence_attendances paa
1259: where paa.business_group_id +0 = p_business_group_id
1260: and paa.person_id = p_person_id
1261: and paa.date_start >= p_date_start;
1262: --

Line 1612: delete from per_absence_attendances paa

1608: loop
1609: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',170);
1610: fetch absenses1 into p_rowid;
1611: exit when absenses1%NOTFOUND;
1612: delete from per_absence_attendances paa
1613: where paa.rowid = p_rowid;
1614: if sql%notfound then
1615: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1616: hr_utility.set_message_token('PROCEDURE','do_cancel_hire');