APPS.PER_ES_ABSENCE dependencies on PER_ABSENCE_ATTENDANCES

Line 282: FROM per_absence_attendances

278: FROM pay_element_entries_f
279: WHERE element_entry_id = l_element_entry_id;
280: --
281: SELECT business_group_id INTO l_bus_grp_id
282: FROM per_absence_attendances
283: WHERE absence_attendance_id = p_absence_attendance_id;
284: --
285: hr_utility.set_location('~~ Before updating ',30);
286: hr_utility.set_location('~~ Absence Att ID ' || to_char(p_absence_attendance_id),10);

Line 368: FROM per_absence_attendances PAA

364: CURSOR csr_get_other_absences(p_person_id NUMBER
365: ,p_date_start DATE
366: ,p_date_end DATE) IS
367: SELECT PAAT.absence_category
368: FROM per_absence_attendances PAA
369: ,per_absence_attendance_types PAAT
370: WHERE PAA.person_id = p_person_id
371: AND PAAT.absence_attendance_type_id = PAA.absence_attendance_type_id
372: AND (( p_date_start BETWEEN PAA.date_start

Line 380: FROM per_absence_attendances PAA

376: --
377: CURSOR csr_validate_ptm(p_person_id NUMBER
378: ,p_date_start DATE) IS
379: SELECT nvl(to_number(max(PAA.date_end) - max(PAA.date_start)+1),0)
380: FROM per_absence_attendances PAA
381: ,per_absence_attendance_types PAAT
382: WHERE PAA.person_id = p_person_id
383: AND PAAT.absence_attendance_type_id = PAA.absence_attendance_type_id
384: AND PAAT.absence_category = 'M'

Line 600: ,per_absence_attendances paa

596: --
597: CURSOR csr_get_absence_category(p_absence_attendance_id NUMBER) IS
598: SELECT paat.absence_category
599: FROM per_absence_attendance_types paat
600: ,per_absence_attendances paa
601: WHERE paa.absence_attendance_id = p_absence_attendance_id
602: AND paat.absence_attendance_type_id = paa.absence_attendance_type_id;
603: --
604: CURSOR csr_get_other_absences(p_absence_attendance_id NUMBER

Line 608: FROM per_absence_attendances PAA1

604: CURSOR csr_get_other_absences(p_absence_attendance_id NUMBER
605: ,p_date_start DATE
606: ,p_date_end DATE) IS
607: SELECT PAAT.absence_category
608: FROM per_absence_attendances PAA1
609: ,per_absence_attendances PAA2
610: ,per_absence_attendance_types PAAT
611: WHERE PAA1.absence_attendance_id = p_absence_attendance_id
612: AND PAA2.person_id = PAA1.person_id

Line 609: ,per_absence_attendances PAA2

605: ,p_date_start DATE
606: ,p_date_end DATE) IS
607: SELECT PAAT.absence_category
608: FROM per_absence_attendances PAA1
609: ,per_absence_attendances PAA2
610: ,per_absence_attendance_types PAAT
611: WHERE PAA1.absence_attendance_id = p_absence_attendance_id
612: AND PAA2.person_id = PAA1.person_id
613: AND PAAT.absence_attendance_type_id = PAA2.absence_attendance_type_id

Line 623: FROM per_absence_attendances PAA1

619: --
620: CURSOR csr_validate_ptm(p_absence_attendance_id NUMBER
621: ,p_date_start DATE) IS
622: SELECT nvl(to_number(max(PAA2.date_end) - max(PAA2.date_start)+1),0)
623: FROM per_absence_attendances PAA1
624: ,per_absence_attendances PAA2
625: ,per_absence_attendance_types PAAT
626: WHERE PAA1.absence_attendance_id = p_absence_attendance_id
627: AND PAA2.person_id = PAA1.person_id

Line 624: ,per_absence_attendances PAA2

620: CURSOR csr_validate_ptm(p_absence_attendance_id NUMBER
621: ,p_date_start DATE) IS
622: SELECT nvl(to_number(max(PAA2.date_end) - max(PAA2.date_start)+1),0)
623: FROM per_absence_attendances PAA1
624: ,per_absence_attendances PAA2
625: ,per_absence_attendance_types PAAT
626: WHERE PAA1.absence_attendance_id = p_absence_attendance_id
627: AND PAA2.person_id = PAA1.person_id
628: AND PAAT.absence_attendance_type_id = PAA2.absence_attendance_type_id

Line 636: FROM per_absence_attendances

632: -- AND p_date_start > PAA2.date_end;
633: --
634: CURSOR get_person_id(p_absence_attendance_id in number) is
635: SELECT person_id
636: FROM per_absence_attendances
637: WHERE absence_attendance_id =p_absence_attendance_id;
638: --
639:
640: CURSOR csr_validate_sex_par(p_person_id NUMBER) IS

Line 649: l_person_id per_absence_attendances.person_id%TYPE;

645: l_sex per_people_f.sex%TYPE;
646:
647: l_maternity_benefit_days NUMBER;
648: l_absence_category per_absence_attendance_types.absence_category%TYPE;
649: l_person_id per_absence_attendances.person_id%TYPE;
650: --
651: BEGIN
652: --
653: -- Added for GSI Bug 5472781