APPS.PA_SEARCH_PVT dependencies on PA_ORG_HIERARCHY_DENORM

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 365: , PA_ORG_HIERARCHY_DENORM ohd

361: , RD.resource_job_level
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)

Line 441: , pa_org_hierarchy_denorm ohd

437: , ter.territory_short_name
438: , loc.region
439: , loc.city
440: FROM pa_project_assignments asgn
441: , pa_org_hierarchy_denorm ohd
442: , pa_projects_all proj
443: , pa_locations loc
444: , fnd_territories_vl ter
445: , pa_project_statuses ps

Line 492: , pa_org_hierarchy_denorm ohd

488: , ter.territory_short_name
489: , loc.region
490: , loc.city
491: FROM pa_project_assignments asgn
492: , pa_org_hierarchy_denorm ohd
493: , pa_projects_all proj
494: , pa_locations loc
495: , fnd_territories_vl ter
496: , pa_project_statuses ps

Line 543: , pa_org_hierarchy_denorm ohd

539: , ter.territory_short_name
540: , loc.region
541: , loc.city
542: FROM pa_project_assignments asgn
543: , pa_org_hierarchy_denorm ohd
544: , pa_projects_all proj
545: , pa_locations loc
546: , fnd_territories_vl ter
547: , pa_project_statuses ps

Line 593: , pa_org_hierarchy_denorm ohd

589: , ter.territory_short_name
590: , loc.region
591: , loc.city
592: FROM pa_project_assignments asgn
593: , pa_org_hierarchy_denorm ohd
594: , pa_projects_all proj
595: , pa_locations loc
596: , fnd_territories_vl ter
597: , pa_project_statuses ps

Line 638: , pa_org_hierarchy_denorm ohd

634: , ter.territory_short_name
635: , loc.region
636: , loc.city
637: FROM pa_project_assignments asgn
638: , pa_org_hierarchy_denorm ohd
639: , pa_projects_all proj
640: , pa_locations loc
641: , fnd_territories_vl ter
642: , pa_project_statuses ps