DBA Data[Home] [Help]

APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on PER_QUALIFICATIONS

Line 3570: from per_qualifications pqa

3566:
3567: -- Qualifications
3568: cursor csr_atr_qual(p_person_id number) is -- Caters for both the two types of Qualifications(Award/Class)
3569: select pqt.qualification_type_id, pqt.name, pqa.awarded_date, pqa.status--event id event name
3570: from per_qualifications pqa
3571: ,per_qualification_types pqt
3572: ,per_establishment_attendances pea
3573: where (pqa.person_id = p_person_id or pea.person_id = p_person_id)
3574: and pqa.start_date <= g_atr_end_date