APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PER_ESTABLISHMENTS

Line 1613: per_establishments pe

1609: pq.license_number
1610: from per_qualifications_vl pq,
1611: per_qualification_types_vl pqt,
1612: per_establishment_attendances pea,
1613: per_establishments pe
1614: where pq.person_id = l_person_id
1615: and nvl(pq.start_date,l_effective_date_ass) <= l_effective_date_ass
1616: and pqt.qualification_type_id = pq.qualification_type_id
1617: and pea.attendance_id (+) = pq.attendance_id