APPS.PAY_FR_SICKNESS_ABSENCE dependencies on PER_ABSENCE_ATTENDANCES

Line 135: from per_absence_attendances

131: l_proc varchar2(200) := g_package||'person_absence_update';
132: --
133: cursor get_person_id(p_absence_attendance_id in number) is
134: select person_id
135: from per_absence_attendances
136: where absence_attendance_id =p_absence_attendance_id;
137: --
138: begin
139: --

Line 326: from per_absence_attendances

322: FROM pay_element_entries_f
323: WHERE element_entry_id = l_element_entry_id;
324:
325: select business_group_id INTO l_bus_grp_id
326: from per_absence_attendances
327: where absence_attendance_id = p_absence_attendance_id;
328:
329: SELECT to_number(substr(to_char(p_date_start,'J'),4,4)) INTO l_sub
330: FROM dual;

Line 395: from per_absence_attendances

391: --
392: -- Cursor to sum up existing absences against entitled holidays
393: Cursor csr_exist_abs(p_from_date date) is
394: Select sum(date_end-date_start+1)
395: from per_absence_attendances
396: where person_id = p_person_id
397: and date_end < p_date_start
398: and date_start >= p_from_date
399: and absence_attendance_type_id = p_absence_attendance_type_id;

Line 482: per_absence_attendances pabs

478: pabs.person_id,
479: pabt.absence_attendance_type_id
480: from pay_accrual_plans pap,
481: per_absence_attendance_types pabt,
482: per_absence_attendances pabs
483: where pabs.absence_attendance_id = p_absence_attendance_id
484: and pabt.absence_attendance_type_id = pabs.absence_attendance_type_id
485: and pap.pto_input_value_id= pabt.input_value_id;
486: --

Line 518: from per_absence_attendances

514: Cursor csr_exist_abs(p_person_id number,
515: p_absence_attendance_type_id number,
516: p_from_date date) is
517: Select sum(date_end-date_start+1)
518: from per_absence_attendances
519: where person_id = p_person_id
520: and date_end < p_date_start
521: and date_start >= p_from_date
522: and absence_attendance_type_id = p_absence_attendance_type_id;