APPS.SSP_PAD_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 44: not to reference from per_absence_attendances

40: to per_all_people_f and per_all_assignments_f
41: 19 Sep 06 Kthampan 5547703 Amend pad_control to call generate_payments
42: with insert-mode if absence is > 0 and
43: also change csr_check_if_existing_entries
44: not to reference from per_absence_attendances
45: table
46: 12 Mar 07 Kthampan 5925760 Amend the cursor csr_existing_entries to
47: use ssp_pad_pkg.c_week_commencing_name
48: */

Line 62: from per_absence_attendances ABSENCE

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

Line 66: from per_absence_attendances paa_tab

62: from per_absence_attendances ABSENCE
63: where absence.maternity_id = p_maternity_id
64: and absence.absence_attendance_id =
65: (select min(paa_tab.absence_attendance_id)
66: from per_absence_attendances paa_tab
67: where paa_tab.maternity_id = absence.maternity_id);
68: --------------------------------------------------------------------------------
69: --
70: -- Get details of the maternal woman

Line 321: from per_absence_attendances

317: --
318: --
319: cursor csr_no_of_absences is
320: select count (*)
321: from per_absence_attendances
322: where person_id = person.person_id
323: and maternity_id = p_maternity_id
324: and absence_attendance_id =
325: (select min(paa_tab.absence_attendance_id)

Line 326: from per_absence_attendances paa_tab

322: where person_id = person.person_id
323: and maternity_id = p_maternity_id
324: and absence_attendance_id =
325: (select min(paa_tab.absence_attendance_id)
326: from per_absence_attendances paa_tab
327: where paa_tab.maternity_id = p_maternity_id);
328: --
329: cursor csr_check_if_existing_entries is
330: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */

Line 1048: from per_absence_attendances

1044: --
1045: cursor csr_no_of_absences is
1046: --
1047: select count (*)
1048: from per_absence_attendances
1049: where person_id = person.person_id
1050: and maternity_id = p_maternity_id
1051: and absence_attendance_id =
1052: (select min(paa_tab.absence_attendance_id)

Line 1053: from per_absence_attendances paa_tab

1049: where person_id = person.person_id
1050: and maternity_id = p_maternity_id
1051: and absence_attendance_id =
1052: (select min(paa_tab.absence_attendance_id)
1053: from per_absence_attendances paa_tab
1054: where paa_tab.maternity_id = p_maternity_id);
1055: --
1056: l_ins_corr_ele boolean;
1057: l_dummy number;

Line 1597: from per_absence_attendances PAA,

1593: --
1594: cursor csr_entries is
1595: select entry.element_entry_id,
1596: entry.effective_start_date
1597: from per_absence_attendances PAA,
1598: per_all_assignments_f PAAF,
1599: pay_element_entries_f entry
1600: where PAA.maternity_id = p_maternity_id
1601: and PAAF.person_id = PAA.person_id

Line 1609: per_absence_attendances ab

1605: --
1606: cursor csr_count_absences is
1607: select count(*)
1608: from ssp_maternities mat,
1609: per_absence_attendances ab
1610: where mat.maternity_id = p_maternity_id
1611: and ab.person_id = mat.person_id
1612: and ab.maternity_id = mat.maternity_id;
1613: --