eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_SEARCH_PVT dependencies on PER_ALL_PEOPLE_F

Line 81: TYPE email_tbl IS TABLE OF per_all_people_f.email_address%TYPE

77: TYPE city_tbl IS TABLE OF pa_locations.city%TYPE
78: INDEX BY BINARY_INTEGER;
79: l_city_tbl city_tbl;
80:
81: TYPE email_tbl IS TABLE OF per_all_people_f.email_address%TYPE
82: INDEX BY BINARY_INTEGER;
83: l_email_tbl email_tbl;
84:
85: TYPE manager_tbl IS TABLE OF pa_resources_denorm.manager_name%TYPE

Line 228: l_res_sql := l_res_sql || ' FROM PA_RESOURCES_DENORM RD, PER_ALL_PEOPLE_F ppf,PA_ORG_HIERARCHY_DENORM ohd, PER_DEPLOYMENT_FACTORS pdf ';

224: -- 'SELECT RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' ||
225: ', RD.resource_organization_id, RD.resource_country_code,RD.resource_country, RD.resource_region '||
226: ', RD.resource_city, RD.resource_job_level, RD.manager_name,PPF.email_address ';
227:
228: l_res_sql := l_res_sql || ' FROM PA_RESOURCES_DENORM RD, PER_ALL_PEOPLE_F ppf,PA_ORG_HIERARCHY_DENORM ohd, PER_DEPLOYMENT_FACTORS pdf ';
229:
230: if p_search_criteria.min_job_level IS NOT NULL then
231: l_res_sql := l_res_sql || ' WHERE RD.resource_job_level >= :1 ';
232: else

Line 366: , PER_ALL_PEOPLE_F ppf

362: , RD.manager_name
363: , PPF.email_address
364: FROM PA_RESOURCES_DENORM RD
365: , PA_ORG_HIERARCHY_DENORM ohd
366: , PER_ALL_PEOPLE_F ppf
367: , PER_DEPLOYMENT_FACTORS pdf
368: WHERE ((p_search_criteria.min_job_level IS NOT NULL AND
369: RD.resource_job_level >= p_search_criteria.min_job_level)
370: OR