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 195: from per_absence_attendances ABSENCE

191: absence.date_start,
192: nvl (absence.date_end, hr_general.end_of_time) date_end,
193: absence.date_notification,
194: absence.accept_late_notification_flag
195: from per_absence_attendances ABSENCE
196: where absence.maternity_id = p_maternity_id
197: order by absence.date_start;
198: --
199: --------------------------------------------------------------------------------

Line 518: from per_absence_attendances

514: --
515: -- Get the number of distinct absences within a maternity pay period
516: --
517: select count (*)
518: from per_absence_attendances
519: where person_id = woman.person_id
520: and maternity_id = p_maternity_id;
521: --
522: -- returns entries associated with a maternity_id.

Line 1570: from per_absence_attendances

1566: --
1567: -- Get the number of distinct absences within a maternity pay period
1568: --
1569: select count (*)
1570: from per_absence_attendances
1571: where person_id = woman.person_id
1572: and maternity_id = p_maternity_id;
1573: --
1574: l_ins_corr_ele boolean;

Line 2203: from per_absence_attendances PAA,

2199: --
2200: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
2201: entry.element_entry_id,
2202: entry.effective_start_date
2203: from per_absence_attendances PAA,
2204: per_all_assignments_f PAAF,
2205: pay_element_entries_f entry
2206: where PAA.maternity_id = p_maternity_id
2207: and PAAF.person_id = PAA.person_id

Line 2215: per_absence_attendances ab

2211: --
2212: cursor csr_count_absences is
2213: select count(*)
2214: from ssp_maternities mat,
2215: per_absence_attendances ab
2216: where mat.maternity_id = p_maternity_id
2217: and ab.person_id = mat.person_id
2218: and ab.maternity_id = mat.maternity_id;
2219: --

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

2306: --------------------------------------------------------------------------------
2307: procedure absence_control (p_maternity_id in number,
2308: p_deleting in boolean ) is
2309: --
2310: -- Handle the event of DML on per_absence_attendances
2311: --
2312: l_proc varchar2 (72) := g_package||'absence_control';
2313: --
2314: begin

Line 2382: from per_absence_attendances abs

2378: 'AA',ssp_apad_pkg.MATCHING_WEEK_OF_ADOPTION(mat.matching_date),
2379: 'AB',ssp_apab_pkg.QUALIFYING_WEEK(mat.due_date),
2380: ssp_smp_pkg.QUALIFYING_WEEK(mat.due_date))
2381: and exists (select 1
2382: from per_absence_attendances abs
2383: where abs.person_id = p_person_id
2384: and abs.maternity_id = mat.maternity_id);
2385: --
2386: l_maternity_id number := null;

Line 2431: from per_absence_attendances ABSENCE

2427: and p_date_of_death <= maternity.MPP_start_date
2428: + (element.element_information6 * 7)
2429: and EXISTS (
2430: select 1
2431: from per_absence_attendances ABSENCE
2432: where ABSENCE.maternity_id = MATERNITY.maternity_id
2433: );
2434: --
2435: l_maternity_id number := null;