APPS.IRC_JPS_GENERATOR dependencies on PER_ALL_PEOPLE_F

Line 173: ||' from per_all_people_f per '

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

Line 479: from per_all_people_f

475: order by creation_date asc;
476: --
477: cursor get_doc_name is
478: select substr(replace(initcap(full_name),' '),1,120)
479: from per_all_people_f
480: where person_id=p_person_id
481: and sysdate between effective_start_date and effective_end_date;
482: l_binary_doc blob;
483: l_character_doc clob;