[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.
58: nvl (absence.date_end, hr_general.end_of_time) date_end,
59: absence.date_notification,
60: absence.accept_late_notification_flag
61: from
62: per_absence_attendances ABSENCE
63: where absence.maternity_id = p_maternity_id
64: order by absence.date_start;
65: --
66: --------------------------------------------------------------------------------
328: --
329: -- Get the number of distinct absences within a maternity pay period
330: --
331: select count (*)
332: from per_absence_attendances
333: where person_id = person.person_id
334: and maternity_id = p_maternity_id;
335: --
336: -- returns entries associated with a maternity_id.
1213: --
1214: -- Get the number of distinct absences within a maternity pay period
1215: --
1216: select count (*)
1217: from per_absence_attendances
1218: where person_id = person.person_id
1219: and maternity_id = p_maternity_id;
1220: --
1221: l_ins_corr_ele boolean;
1758: --
1759: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
1760: entry.element_entry_id,
1761: entry.effective_start_date
1762: from per_absence_attendances PAA,
1763: per_all_assignments_f PAAF,
1764: pay_element_entries_f entry
1765: where PAA.maternity_id = p_maternity_id
1766: and PAAF.person_id = PAA.person_id
1770: --
1771: cursor csr_count_absences is
1772: select count(*)
1773: from ssp_maternities mat,
1774: per_absence_attendances ab
1775: where mat.maternity_id = p_maternity_id
1776: and ab.person_id = mat.person_id
1777: and ab.maternity_id = mat.maternity_id;
1778: --