APPS.SSP_PAB_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 45: not to reference from per_absence_attendances

41: to per_all_people_f and per_all_assignments_f
42: 19 Spe 06 5547703 KThampan Amend pab_control to call generate_payments
43: with insert-mode if absence is > 0 and
44: also change csr_check_if_existing_entries
45: not to reference from per_absence_attendances
46: table
47: 26 Jul 09 8692219 npannamp Changed the To_Date function to
48: fnd_date.chardate_to_date function in
49: the cursor csr_existing_entries.

Line 64: per_absence_attendances ABSENCE

60: nvl (absence.date_end, hr_general.end_of_time) date_end,
61: absence.date_notification,
62: absence.accept_late_notification_flag
63: from
64: per_absence_attendances ABSENCE
65: where absence.maternity_id = p_maternity_id
66: and absence.absence_attendance_id =
67: (select min(paa_tab.absence_attendance_id)
68: from per_absence_attendances paa_tab

Line 68: from per_absence_attendances paa_tab

64: per_absence_attendances ABSENCE
65: where absence.maternity_id = p_maternity_id
66: and absence.absence_attendance_id =
67: (select min(paa_tab.absence_attendance_id)
68: from per_absence_attendances paa_tab
69: where paa_tab.maternity_id = absence.maternity_id);
70: --
71: --------------------------------------------------------------------------------
72: cursor csr_personal_details (p_maternity_id in number) is

Line 361: from per_absence_attendances

357: --
358: cursor csr_no_of_absences is
359: --
360: select count (*)
361: from per_absence_attendances
362: where person_id = person.person_id
363: and maternity_id = p_maternity_id
364: and absence_attendance_id =
365: (select min(paa_tab.absence_attendance_id)

Line 366: from per_absence_attendances paa_tab

362: where person_id = person.person_id
363: and maternity_id = p_maternity_id
364: and absence_attendance_id =
365: (select min(paa_tab.absence_attendance_id)
366: from per_absence_attendances paa_tab
367: where paa_tab.maternity_id = p_maternity_id);
368: --
369: -- returns entries associated with a maternity_id.
370: cursor csr_check_if_existing_entries is

Line 1139: from per_absence_attendances

1135: --
1136: cursor csr_no_of_absences is
1137: --
1138: select count (*)
1139: from per_absence_attendances
1140: where person_id = person.person_id
1141: and maternity_id = p_maternity_id
1142: and absence_attendance_id =
1143: (select min(paa_tab.absence_attendance_id)

Line 1144: from per_absence_attendances paa_tab

1140: where person_id = person.person_id
1141: and maternity_id = p_maternity_id
1142: and absence_attendance_id =
1143: (select min(paa_tab.absence_attendance_id)
1144: from per_absence_attendances paa_tab
1145: where paa_tab.maternity_id = p_maternity_id); --Bug fix 4226911
1146:
1147:
1148: --

Line 1695: from per_absence_attendances PAA,

1691: --
1692: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
1693: entry.element_entry_id,
1694: entry.effective_start_date
1695: from per_absence_attendances PAA,
1696: per_all_assignments_f PAAF,
1697: pay_element_entries_f entry
1698: where PAA.maternity_id = p_maternity_id
1699: and PAAF.person_id = PAA.person_id

Line 1707: per_absence_attendances ab

1703: --
1704: cursor csr_count_absences is
1705: select count(*)
1706: from ssp_maternities mat,
1707: per_absence_attendances ab
1708: where mat.maternity_id = p_maternity_id
1709: and ab.person_id = mat.person_id
1710: and ab.maternity_id = mat.maternity_id;
1711: --