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 221: 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 ';

217: -- 'SELECT RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' ||
218: ', RD.resource_organization_id, RD.resource_country_code,RD.resource_country, RD.resource_region '||
219: ', RD.resource_city, RD.resource_job_level, RD.manager_name,PPF.email_address ';
220:
221: 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 ';
222:
223: if p_search_criteria.min_job_level IS NOT NULL then
224: l_res_sql := l_res_sql || ' WHERE RD.resource_job_level >= :1 ';
225: else

Line 358: , PER_ALL_PEOPLE_F ppf

354: , RD.manager_name
355: , PPF.email_address
356: FROM PA_RESOURCES_DENORM RD
357: , PA_ORG_HIERARCHY_DENORM ohd
358: , PER_ALL_PEOPLE_F ppf
359: , PER_DEPLOYMENT_FACTORS pdf
360: WHERE ((p_search_criteria.min_job_level IS NOT NULL AND
361: RD.resource_job_level >= p_search_criteria.min_job_level)
362: OR