APPS.SSP_MAT_BUS dependencies on PER_ABSENCE_ATTENDANCES

Line 254: from per_absence_attendances paa

250:
251: cursor pregnancy_related_absences is
252: select paa.sickness_start_date,
253: paa.sickness_end_date
254: from per_absence_attendances paa
255: where paa.person_id = p_person_id
256: and paa.pregnancy_related_illness = 'Y'
257: and (p_ewc - 28) <= nvl(paa.sickness_end_date, fnd_date.canonical_to_date('4712/12/31 00:00:00'))
258: and p_ewc >= paa.sickness_start_date;

Line 680: from per_absence_attendances

676: Procedure check_kit_days(p_rec in ssp_mat_shd.g_rec_type) is
677:
678: cursor c_get_ma_end_date is /* Bug 6003570 */
679: select max(date_end) end_date
680: from per_absence_attendances
681: where maternity_id=p_rec.maternity_id;
682:
683: l_2_weeks constant number := 14;
684: l_2_weeks_after_birth date;