APPS.SSP_SMP_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 166: not to reference from per_absence_attendances

162: to per_all_people_f and per_all_assignments_f
163: 19-SEP-2006 kthampan 115.31 5547703 Amend smp_control to call generate_payments
164: with insert-mode if absence is > 0 and
165: also change csr_check_if_existing_entries
166: not to reference from per_absence_attendances
167: table
168: 19-OCT-2006 kthampan 115.32 5604330 Amend check_death to create the stoppage based
169: on the '7 day rolling weeks', currently it
170: will always created using the next Sunday after

Line 188: from per_absence_attendances ABSENCE

184: absence.date_start,
185: nvl (absence.date_end, hr_general.end_of_time) date_end,
186: absence.date_notification,
187: absence.accept_late_notification_flag
188: from per_absence_attendances ABSENCE
189: where absence.maternity_id = p_maternity_id
190: order by absence.date_start;
191: --
192: --------------------------------------------------------------------------------

Line 511: from per_absence_attendances

507: --
508: -- Get the number of distinct absences within a maternity pay period
509: --
510: select count (*)
511: from per_absence_attendances
512: where person_id = woman.person_id
513: and maternity_id = p_maternity_id;
514: --
515: -- returns entries associated with a maternity_id.

Line 1491: from per_absence_attendances

1487: --
1488: -- Get the number of distinct absences within a maternity pay period
1489: --
1490: select count (*)
1491: from per_absence_attendances
1492: where person_id = woman.person_id
1493: and maternity_id = p_maternity_id;
1494: --
1495: l_ins_corr_ele boolean;

Line 2124: from per_absence_attendances PAA,

2120: --
2121: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
2122: entry.element_entry_id,
2123: entry.effective_start_date
2124: from per_absence_attendances PAA,
2125: per_all_assignments_f PAAF,
2126: pay_element_entries_f entry
2127: where PAA.maternity_id = p_maternity_id
2128: and PAAF.person_id = PAA.person_id

Line 2136: per_absence_attendances ab

2132: --
2133: cursor csr_count_absences is
2134: select count(*)
2135: from ssp_maternities mat,
2136: per_absence_attendances ab
2137: where mat.maternity_id = p_maternity_id
2138: and ab.person_id = mat.person_id
2139: and ab.maternity_id = mat.maternity_id;
2140: --

Line 2231: -- Handle the event of DML on per_absence_attendances

2227: --------------------------------------------------------------------------------
2228: procedure absence_control (p_maternity_id in number,
2229: p_deleting in boolean ) is
2230: --
2231: -- Handle the event of DML on per_absence_attendances
2232: --
2233: l_proc varchar2 (72) := g_package||'absence_control';
2234: --
2235: begin

Line 2301: from per_absence_attendances abs

2297: 'PA',ssp_pad_pkg.MATCHING_WEEK_OF_ADOPTION(mat.matching_date),
2298: 'PB',ssp_pab_pkg.QUALIFYING_WEEK(mat.due_date),
2299: ssp_smp_pkg.QUALIFYING_WEEK(mat.due_date))
2300: and exists (select 1
2301: from per_absence_attendances abs
2302: where abs.person_id = p_person_id
2303: and abs.maternity_id = mat.maternity_id);
2304: --
2305: l_maternity_id number := null;

Line 2350: from per_absence_attendances ABSENCE

2346: and p_date_of_death <= maternity.MPP_start_date
2347: + (element.element_information6 * 7)
2348: and EXISTS (
2349: select 1
2350: from per_absence_attendances ABSENCE
2351: where ABSENCE.maternity_id = MATERNITY.maternity_id
2352: );
2353: --
2354: l_maternity_id number := null;