APPS.PAY_FR_MAP_CALC dependencies on PER_ABSENCE_ATTENDANCES

Line 181: from per_absence_attendances

177: p_confinement_date date,
178: p_parent_absence_id number,
179: p_person_id number) is
180: select sum(date_end - date_start +1 ) duration
181: from per_absence_attendances
182: where person_id = p_person_id
183: and abs_information_category = 'FR_M'
184: and date_end < p_end_date
185: and date_end > p_confinement_date

Line 380: from per_absence_attendances

376:
377: Cursor c_prev_ante_natal_abs(p_start_date date
378: ,p_person_id number) is
379: select sum(date_end - date_start +1 ) duration
380: from per_absence_attendances
381: where person_id = p_person_id
382: and abs_information_category = 'FR_M'
383: and abs_information4 is null
384: and date_start >= add_months(p_start_date,-9)

Line 552: from per_absence_attendances paa

548: , paa.abs_information7
549: , paa.abs_information8
550: , paa.abs_information9
551: , paa.abs_information10
552: from per_absence_attendances paa
553: where paa.absence_attendance_id = p_absence_attendance_id;
554:
555: cursor c_get_parent_maternity(p_parent_absence_id number) is
556: SELECT pabs.abs_information2 elig_gi,

Line 566: FROM per_absence_attendances pabs

562: fnd_number.canonical_to_number (pabs.abs_information9)
563: elig_ijss_contrib,
564: pabs.date_start abs_start,
565: pabs.date_end abs_end
566: FROM per_absence_attendances pabs
567: WHERE pabs.absence_attendance_id = p_parent_absence_id;
568:
569: cursor c_get_child_absence(p_person_id number
570: ,p_parent_absence_id number

Line 576: from per_absence_attendances

572: select absence_attendance_id
573: , date_start
574: , date_end
575: , date_end - date_start + 1 duration
576: from per_absence_attendances
577: where person_id = p_person_id
578: and date_end <= p_max_end_date
579: and abs_information1 = fnd_number.number_to_canonical(p_parent_absence_id)
580: order by date_start;

Line 805: from per_absence_attendances paa

801: , paa.date_start
802: , paa.date_end
803: , decode(paa.abs_information_category,'FR_M',to_number(paa.abs_information1)) parent_absence_id
804: , decode(paa.abs_information_category,'FR_M',NVL(paa.abs_information7,'N'),NVL(paa.abs_information4,'N')) estimated_ijss
805: from per_absence_attendances paa
806: ,per_assignments_f paf
807: where paf.assignment_id = p_assignment_id
808: and paf.person_id = paa.person_id
809: and p_date_earned between

Line 816: from per_absence_attendances paa

812: and paa.abs_information_category IN ('FR_M','FR_FR_PATERNITY','FR_FR_ADOPTION');
813:
814: cursor c_get_parent_absence(p_absence_attendance_id number) is
815: select paa.abs_information7 estimated_ijss
816: from per_absence_attendances paa
817: where paa.absence_attendance_id = p_absence_attendance_id;
818:
819: TYPE t_absence is RECORD
820: (absence_attendance_id number