APPS.SSP_APAB_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 34: per_absence_attendances ABSENCE

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

Line 38: from per_absence_attendances paa_tab

34: per_absence_attendances ABSENCE
35: where absence.maternity_id = p_maternity_id
36: and absence.absence_attendance_id =
37: (select min(paa_tab.absence_attendance_id)
38: from per_absence_attendances paa_tab
39: where paa_tab.maternity_id = absence.maternity_id);
40: --
41: --------------------------------------------------------------------------------
42: cursor csr_personal_details (p_maternity_id in number) is

Line 387: from per_absence_attendances

383: --
384: cursor csr_no_of_absences is
385: --
386: select count (*)
387: from per_absence_attendances
388: where person_id = person.person_id
389: and maternity_id = p_maternity_id
390: and absence_attendance_id =
391: (select min(paa_tab.absence_attendance_id)

Line 392: from per_absence_attendances paa_tab

388: where person_id = person.person_id
389: and maternity_id = p_maternity_id
390: and absence_attendance_id =
391: (select min(paa_tab.absence_attendance_id)
392: from per_absence_attendances paa_tab
393: where paa_tab.maternity_id = p_maternity_id);
394: --
395: -- returns entries associated with a maternity_id.
396: cursor csr_check_if_existing_entries is

Line 1097: from per_absence_attendances

1093: --
1094: cursor csr_no_of_absences is
1095: --
1096: select count (*)
1097: from per_absence_attendances
1098: where person_id = person.person_id
1099: and maternity_id = p_maternity_id
1100: and absence_attendance_id =
1101: (select min(paa_tab.absence_attendance_id)

Line 1102: from per_absence_attendances paa_tab

1098: where person_id = person.person_id
1099: and maternity_id = p_maternity_id
1100: and absence_attendance_id =
1101: (select min(paa_tab.absence_attendance_id)
1102: from per_absence_attendances paa_tab
1103: where paa_tab.maternity_id = p_maternity_id); --Bug fix 4226911
1104:
1105:
1106: --

Line 1701: from per_absence_attendances PAA,

1697: --
1698: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
1699: entry.element_entry_id,
1700: entry.effective_start_date
1701: from per_absence_attendances PAA,
1702: per_all_assignments_f PAAF,
1703: pay_element_entries_f entry
1704: where PAA.maternity_id = p_maternity_id
1705: and PAAF.person_id = PAA.person_id

Line 1713: per_absence_attendances ab

1709: --
1710: cursor csr_count_absences is
1711: select count(*)
1712: from ssp_maternities mat,
1713: per_absence_attendances ab
1714: where mat.maternity_id = p_maternity_id
1715: and ab.person_id = mat.person_id
1716: and ab.maternity_id = mat.maternity_id;
1717: --