DBA Data[Home] [Help]

APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on PER_QUALIFICATIONS

Line 3576: from per_qualifications pqa

3572:
3573: -- Qualifications
3574: cursor csr_atr_qual(p_person_id number) is -- Caters for both the two types of Qualifications(Award/Class)
3575: select pqt.qualification_type_id, pqt.name, pqa.awarded_date, pqa.status--event id event name
3576: from per_qualifications pqa
3577: ,per_qualification_types pqt
3578: ,per_establishment_attendances pea
3579: where (pqa.person_id = p_person_id or pea.person_id = p_person_id)
3580: and pqa.start_date <= g_atr_end_date