APPS.PA_SEARCH_PVT dependencies on PA_ORG_HIERARCHY_DENORM

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

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

Line 433: , pa_org_hierarchy_denorm ohd

429: , ter.territory_short_name
430: , loc.region
431: , loc.city
432: FROM pa_project_assignments asgn
433: , pa_org_hierarchy_denorm ohd
434: , pa_projects_all proj
435: , pa_locations loc
436: , fnd_territories_vl ter
437: , pa_project_statuses ps

Line 484: , pa_org_hierarchy_denorm ohd

480: , ter.territory_short_name
481: , loc.region
482: , loc.city
483: FROM pa_project_assignments asgn
484: , pa_org_hierarchy_denorm ohd
485: , pa_projects_all proj
486: , pa_locations loc
487: , fnd_territories_vl ter
488: , pa_project_statuses ps

Line 535: , pa_org_hierarchy_denorm ohd

531: , ter.territory_short_name
532: , loc.region
533: , loc.city
534: FROM pa_project_assignments asgn
535: , pa_org_hierarchy_denorm ohd
536: , pa_projects_all proj
537: , pa_locations loc
538: , fnd_territories_vl ter
539: , pa_project_statuses ps

Line 585: , pa_org_hierarchy_denorm ohd

581: , ter.territory_short_name
582: , loc.region
583: , loc.city
584: FROM pa_project_assignments asgn
585: , pa_org_hierarchy_denorm ohd
586: , pa_projects_all proj
587: , pa_locations loc
588: , fnd_territories_vl ter
589: , pa_project_statuses ps

Line 630: , pa_org_hierarchy_denorm ohd

626: , ter.territory_short_name
627: , loc.region
628: , loc.city
629: FROM pa_project_assignments asgn
630: , pa_org_hierarchy_denorm ohd
631: , pa_projects_all proj
632: , pa_locations loc
633: , fnd_territories_vl ter
634: , pa_project_statuses ps