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: */
48: --------------------------------------------------------------------------------
49: g_package varchar2(33) := ' ssp_pab_pkg.'; -- Global package name

Line 61: per_absence_attendances ABSENCE

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

Line 65: from per_absence_attendances paa_tab

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

Line 358: from per_absence_attendances

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

Line 363: from per_absence_attendances paa_tab

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

Line 1130: from per_absence_attendances

1126: --
1127: cursor csr_no_of_absences is
1128: --
1129: select count (*)
1130: from per_absence_attendances
1131: where person_id = person.person_id
1132: and maternity_id = p_maternity_id
1133: and absence_attendance_id =
1134: (select min(paa_tab.absence_attendance_id)

Line 1135: from per_absence_attendances paa_tab

1131: where person_id = person.person_id
1132: and maternity_id = p_maternity_id
1133: and absence_attendance_id =
1134: (select min(paa_tab.absence_attendance_id)
1135: from per_absence_attendances paa_tab
1136: where paa_tab.maternity_id = p_maternity_id); --Bug fix 4226911
1137:
1138:
1139: --

Line 1686: from per_absence_attendances PAA,

1682: --
1683: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
1684: entry.element_entry_id,
1685: entry.effective_start_date
1686: from per_absence_attendances PAA,
1687: per_all_assignments_f PAAF,
1688: pay_element_entries_f entry
1689: where PAA.maternity_id = p_maternity_id
1690: and PAAF.person_id = PAA.person_id

Line 1698: per_absence_attendances ab

1694: --
1695: cursor csr_count_absences is
1696: select count(*)
1697: from ssp_maternities mat,
1698: per_absence_attendances ab
1699: where mat.maternity_id = p_maternity_id
1700: and ab.person_id = mat.person_id
1701: and ab.maternity_id = mat.maternity_id;
1702: --