APPS.PER_ZA_WSP_LOOKUP dependencies on PER_ALL_ASSIGNMENTS_F

Line 357: , per_all_assignments_f paa

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
361: And pce.EFFECTIVE_DATE_FROM between pp.effective_start_date

Line 400: , per_all_assignments_f paa

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
404: and paa.assignment_type = 'E'

Line 452: , per_all_assignments_f paa

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'
456: And ( OLE.COMPLETION_DATE between g_plan_year_start_date

Line 512: , per_all_assignments_f paa

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
516: AND NVL(OE.course_end_DATE, g_plan_year_start_date) >= g_plan_year_start_date

Line 574: , per_all_assignments_f paa

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
578: And paa.person_id = pp.person_id

Line 699: , per_all_assignments_f paa

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
703: AND NVL(OE.course_end_DATE, g_trnd_year_start_date) >= g_trnd_year_start_date