[Home] [Help]
APPS.PER_ZA_WSP_LOOKUP dependencies on PER_COMPETENCE_ELEMENTS
Line 354: Per_competence_elements pce
350: And org_i.ORG_INFORMATION9 = 'ZA')
351: )
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