[Home] [Help]
31: 23-AUG-06 K Thampan 5482199 Statutory changes for 2007
32: 19-SEP-06 K Thampan 5547703 Amend sap_control to call generate_payments
33: with insert-mode if absence is > 0 and
34: also change csr_check_if_existing_entries
35: not to reference from per_absence_attendances
36: table
37: 19-OCT-06 K Thampan 5604330 Amended function entitled_to_sap to
38: check for employee date of death before creating
39: 'Some work was done' stoppage.
56: nvl (absence.date_end, hr_general.end_of_time) date_end,
57: absence.date_notification,
58: absence.accept_late_notification_flag
59: from
60: per_absence_attendances ABSENCE
61: where absence.maternity_id = p_maternity_id
62: order by absence.date_start;
63: --
64: --------------------------------------------------------------------------------
326: --
327: -- Get the number of distinct absences within a maternity pay period
328: --
329: select count (*)
330: from per_absence_attendances
331: where person_id = person.person_id
332: and maternity_id = p_maternity_id;
333: --
334: -- returns entries associated with a maternity_id.
1206: --
1207: -- Get the number of distinct absences within a maternity pay period
1208: --
1209: select count (*)
1210: from per_absence_attendances
1211: where person_id = person.person_id
1212: and maternity_id = p_maternity_id;
1213: --
1214: l_ins_corr_ele boolean;
1751: --
1752: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
1753: entry.element_entry_id,
1754: entry.effective_start_date
1755: from per_absence_attendances PAA,
1756: per_all_assignments_f PAAF,
1757: pay_element_entries_f entry
1758: where PAA.maternity_id = p_maternity_id
1759: and PAAF.person_id = PAA.person_id
1763: --
1764: cursor csr_count_absences is
1765: select count(*)
1766: from ssp_maternities mat,
1767: per_absence_attendances ab
1768: where mat.maternity_id = p_maternity_id
1769: and ab.person_id = mat.person_id
1770: and ab.maternity_id = mat.maternity_id;
1771: --