APPS.IRC_JPS_GENERATOR dependencies on PER_ALL_PEOPLE_F

Line 172: ||' from per_all_people_f per '

168: ||' where ipacv.search_criteria_id=isc.search_criteria_id) as professional_areas'
169: ||' from irc_search_criteria isc'
170: ||' where isc.object_id=per.person_id'
171: ||' and isc.object_type=''WPREF'') as work_preferences'
172: ||' from per_all_people_f per '
173: ||' ,fnd_user usr '
174: ||' ,per_person_types_tl ppttl '
175: ||' where per.person_id = :1'
176: ||' and usr.employee_id(+)=per.person_id'

Line 471: from per_all_people_f

467: order by creation_date asc;
468: --
469: cursor get_doc_name is
470: select substr(replace(initcap(full_name),' '),1,120)
471: from per_all_people_f
472: where person_id=p_person_id
473: and sysdate between effective_start_date and effective_end_date;
474: l_binary_doc blob;
475: l_character_doc clob;