APPS.SSP_APAD_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 35: from per_absence_attendances ABSENCE

31: absence.date_start,
32: nvl (absence.date_end, hr_general.end_of_time) date_end,
33: absence.date_notification,
34: absence.accept_late_notification_flag
35: from per_absence_attendances ABSENCE
36: where absence.maternity_id = p_maternity_id
37: and absence.absence_attendance_id =
38: (select min(paa_tab.absence_attendance_id)
39: from per_absence_attendances paa_tab

Line 39: from per_absence_attendances paa_tab

35: from per_absence_attendances ABSENCE
36: where absence.maternity_id = p_maternity_id
37: and absence.absence_attendance_id =
38: (select min(paa_tab.absence_attendance_id)
39: from per_absence_attendances paa_tab
40: where paa_tab.maternity_id = absence.maternity_id);
41: --------------------------------------------------------------------------------
42: --
43: -- Get details of the maternal woman

Line 344: from per_absence_attendances

340: --
341: --
342: cursor csr_no_of_absences is
343: select count (*)
344: from per_absence_attendances
345: where person_id = person.person_id
346: and maternity_id = p_maternity_id
347: and absence_attendance_id =
348: (select min(paa_tab.absence_attendance_id)

Line 349: from per_absence_attendances paa_tab

345: where person_id = person.person_id
346: and maternity_id = p_maternity_id
347: and absence_attendance_id =
348: (select min(paa_tab.absence_attendance_id)
349: from per_absence_attendances paa_tab
350: where paa_tab.maternity_id = p_maternity_id);
351: --
352: cursor csr_check_if_existing_entries is
353: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */

Line 1020: from per_absence_attendances

1016: --
1017: cursor csr_no_of_absences is
1018: --
1019: select count (*)
1020: from per_absence_attendances
1021: where person_id = person.person_id
1022: and maternity_id = p_maternity_id
1023: and absence_attendance_id =
1024: (select min(paa_tab.absence_attendance_id)

Line 1025: from per_absence_attendances paa_tab

1021: where person_id = person.person_id
1022: and maternity_id = p_maternity_id
1023: and absence_attendance_id =
1024: (select min(paa_tab.absence_attendance_id)
1025: from per_absence_attendances paa_tab
1026: where paa_tab.maternity_id = p_maternity_id);
1027: --
1028: l_ins_corr_ele boolean;
1029: l_dummy number;

Line 1617: from per_absence_attendances PAA,

1613: --
1614: cursor csr_entries is
1615: select entry.element_entry_id,
1616: entry.effective_start_date
1617: from per_absence_attendances PAA,
1618: per_all_assignments_f PAAF,
1619: pay_element_entries_f entry
1620: where PAA.maternity_id = p_maternity_id
1621: and PAAF.person_id = PAA.person_id

Line 1629: per_absence_attendances ab

1625: --
1626: cursor csr_count_absences is
1627: select count(*)
1628: from ssp_maternities mat,
1629: per_absence_attendances ab
1630: where mat.maternity_id = p_maternity_id
1631: and ab.person_id = mat.person_id
1632: and ab.maternity_id = mat.maternity_id;
1633: --