DBA Data[Home] [Help]

APPS.PAY_AE_SI_REPORTS dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 220: from per_establishments est, per_establishment_attendances pea, per_qualifications pq

216:
217: /* Cursor to fetch establishment name */
218: CURSOR get_est_name (l_attendance_id number) IS
219: select est.name
220: from per_establishments est, per_establishment_attendances pea, per_qualifications pq
221: where pq.attendance_id = l_attendance_id
222: and pq.attendance_id = pea.attendance_id
223: and est.establishment_id = pea.establishment_id;
224: