APPS.PER_ES_ABSENCE dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 361: FROM per_absence_attendance_types

357: ,p_abs_information10 IN VARCHAR2) IS
358: --
359: CURSOR csr_get_absence_category(p_absence_attendance_type_id NUMBER) IS
360: SELECT absence_category
361: FROM per_absence_attendance_types
362: WHERE absence_attendance_type_id = p_absence_attendance_type_id;
363: --
364: CURSOR csr_get_other_absences(p_person_id NUMBER
365: ,p_date_start DATE

Line 369: ,per_absence_attendance_types PAAT

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
373: AND NVL(PAA.date_end,to_date('31-12-4712','DD-MM-YYYY')))

Line 381: ,per_absence_attendance_types PAAT

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'
385: AND p_date_start = PAA.date_end + 1 ;

Line 397: l_absence_category per_absence_attendance_types.absence_category%TYPE;

393:
394: l_sex per_people_f.sex%TYPE;
395:
396: l_maternity_benefit_days NUMBER;
397: l_absence_category per_absence_attendance_types.absence_category%TYPE;
398: --
399: BEGIN
400: --
401: -- Added for GSI Bug 5472781

Line 599: FROM per_absence_attendance_types paat

595: ,p_abs_information10 IN VARCHAR2) IS
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: --

Line 610: ,per_absence_attendance_types PAAT

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
614: AND PAA1.absence_attendance_id <> PAA2.absence_attendance_id

Line 625: ,per_absence_attendance_types PAAT

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
629: AND PAA1.absence_attendance_id <> PAA2.absence_attendance_id

Line 648: l_absence_category per_absence_attendance_types.absence_category%TYPE;

644:
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: --