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 779: from per_absence_attendances

775: Procedure check_kit_days(p_rec in ssp_mat_shd.g_rec_type) is
776:
777: cursor c_get_ma_end_date is /* Bug 6003570 */
778: select max(date_end) end_date
779: from per_absence_attendances
780: where maternity_id=p_rec.maternity_id;
781:
782: l_2_weeks constant number := 14;
783: l_2_weeks_after_birth date;