DBA Data[Home] [Help]

APPS.HR_SUIT_MATCH_UTIL_SS dependencies on PER_ALL_PEOPLE_F

Line 615: per_all_people_f ppf

611: 'SM','POS')),'JOB')),'ORG')),'BUS') type,
612: ppf.person_id
613: FROM per_competence_elements pce,
614: per_suitmatch_person pcp,
615: per_all_people_f ppf
616: WHERE pce.type = 'REQUIREMENT'
617: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
618: and nvl(pce.effective_date_to, trunc(sysdate))
619: AND pce.business_group_id = decode(hr_general.get_xbg_profile,