APPS.HR_NL_DAILY_SICK_AND_RECOVERY dependencies on PER_ABSENCE_ATTENDANCES

Line 90: from per_absence_attendances

86: ,date_projected_end
87: ,date_start
88: ,date_projected_start
89: ,abs_information1
90: from per_absence_attendances
91: where absence_attendance_id = p_absence_attendance_id;
92: --
93: l_rec cur_per_abs_chags%ROWTYPE;
94: --

Line 181: -- This cursor fetchs old data from PER_ABSENCE_ATTENDANCES

177: --
178: PROCEDURE delete_person_absence_changes
179: (p_absence_attendance_id IN number) IS
180: --
181: -- This cursor fetchs old data from PER_ABSENCE_ATTENDANCES
182: -- required to maitain the details of the deleted absence.
183: --
184: cursor cur_per_abs_chags is
185: select person_id

Line 191: from per_absence_attendances

187: ,date_projected_end
188: ,date_start
189: ,date_projected_start
190: ,abs_information1
191: from per_absence_attendances
192: where absence_attendance_id = p_absence_attendance_id;
193: --
194: l_rec cur_per_abs_chags%ROWTYPE;
195: --

Line 330: from per_absence_attendances paa,

326: -- cursor will fetch absence_category
327: --
328: cursor cur_per_abs_s_chags is
329: select paat.absence_category
330: from per_absence_attendances paa,
331: per_absence_attendance_types paat
332: where paa.absence_attendance_type_id
333: = paat.absence_attendance_type_id
334: and paa.absence_attendance_id = p_absence_attendance_id