APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 547: from per_absence_attendances paa

543: -- absenses cursor
544: --
545: cursor absenses is
546: select rowid
547: from per_absence_attendances paa
548: where paa.business_group_id +0 = p_business_group_id
549: and paa.person_id = p_person_id
550: and paa.date_start >= p_primary_date
551: for update of person_id;

Line 2169: from per_absence_attendances paa

2165: -- absenses cursor
2166: --
2167: cursor absenses1 is
2168: select rowid
2169: from per_absence_attendances paa
2170: where paa.business_group_id +0 = p_business_group_id
2171: and paa.person_id = p_person_id
2172: and paa.date_start >= p_date_start;
2173: --

Line 2532: delete from per_absence_attendances paa

2528: loop
2529: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',170);
2530: fetch absenses1 into p_rowid;
2531: exit when absenses1%NOTFOUND;
2532: delete from per_absence_attendances paa
2533: where paa.rowid = p_rowid;
2534: if sql%notfound then
2535: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2536: hr_utility.set_message_token('PROCEDURE','do_cancel_hire');