DBA Data[Home] [Help]

APPS.IRC_QUA_UPDATE dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 22: ,per_establishment_attendances pea

18: select pea.person_id person_id
19: ,pea.business_group_id business_group_id
20: ,pq.attendance_id attendance_id
21: from per_qualifications pq
22: ,per_establishment_attendances pea
23: where pea.attendance_id = pq.attendance_id
24: and pea.attendance_id between p_start_pkid and p_end_pkid
25: and pq.person_id is null
26: and pq.business_group_id is null;