eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ZA_WSP_LOOKUP dependencies on PER_ALL_PEOPLE_F

Line 356: , per_all_people_f pp

352: And exists
353: ( Select 1 from
354: Per_competence_elements pce
355: , HR_ORGANIZATION_INFORMATION org_i
356: , per_all_people_f pp
357: , per_all_assignments_f paa
358: Where pce.competence_id = pc.COMPETENCE_ID
359: And pce.type = 'PERSONAL'
360: And pce.person_id = pp.person_id

Line 399: , per_all_people_f pp

395: ( Select pq.qualification_type_id
396: from
397: per_qualifications pq
398: , PER_ESTABLISHMENT_ATTENDANCES pea
399: , per_all_people_f pp
400: , per_all_assignments_f paa
401: , HR_ORGANIZATION_INFORMATION org_i
402: Where pqt.qualification_type_id = pq.qualification_type_id
403: And paa.person_id = pp.person_id

Line 451: , per_all_people_f pp

447: From
448: OTA_LP_ENROLLMENTS OLE
449: , HR_ORGANIZATION_INFORMATION org_i
450: , OTA_LP_MEMBER_ENROLLMENTS OLME
451: , per_all_people_f pp
452: , per_all_assignments_f paa
453: Where OLE.LEARNING_PATH_ID = lp_rec.LOOKUP_CODE
454: And OLME.LP_ENROLLMENT_ID = OLE.LP_ENROLLMENT_ID
455: And OLE.PATH_STATUS_CODE <> 'CANCELLED'

Line 511: , per_all_people_f pp

507: OTA_EVENTS oe
508: , OTA_DELEGATE_BOOKINGS odb
509: , OTA_BOOKING_STATUS_TYPES obst
510: , HR_ORGANIZATION_INFORMATION org_i
511: , per_all_people_f pp
512: , per_all_assignments_f paa
513: wHERE ACTIVITY_VERSION_ID = course_rec.LOOKUP_CODE
514: aND oe.EVENT_TYPE in ( 'SCHEDULED', 'SELFPACED')
515: AND OE.course_START_DATE <= g_plan_year_end_date

Line 573: , per_all_people_f pp

569: into l_count
570: From
571: OTA_CERT_ENROLLMENTS OCE
572: , HR_ORGANIZATION_INFORMATION org_i
573: , per_all_people_f pp
574: , per_all_assignments_f paa
575: Where
576: OCE.CERTIFICATION_ID = cert_rec.LOOKUP_CODE
577: And OCE.PERSON_ID = PP.person_id

Line 698: , per_all_people_f pp

694: OTA_EVENTS oe
695: , OTA_DELEGATE_BOOKINGS odb
696: , OTA_BOOKING_STATUS_TYPES obst
697: , HR_ORGANIZATION_INFORMATION org_i
698: , per_all_people_f pp
699: , per_all_assignments_f paa
700: wHERE ACTIVITY_VERSION_ID = course_rec.LOOKUP_CODE
701: aND oe.EVENT_TYPE in ( 'SCHEDULED', 'SELFPACED')
702: AND OE.course_START_DATE <= g_trnd_year_end_date