APPS.PA_SEARCH_PVT dependencies on FND_TERRITORIES_VL

Line 65: TYPE country_code_tbl IS TABLE OF fnd_territories_vl.territory_code%TYPE

61: TYPE resource_organization_id_tbl IS TABLE OF pa_resources_denorm.resource_organization_id%TYPE
62: INDEX BY BINARY_INTEGER;
63: l_resource_organization_id_tbl resource_organization_id_tbl;
64:
65: TYPE country_code_tbl IS TABLE OF fnd_territories_vl.territory_code%TYPE
66: INDEX BY BINARY_INTEGER;
67: l_country_code_tbl country_code_tbl;
68:
69: TYPE country_tbl IS TABLE OF fnd_territories_vl.territory_short_name%TYPE

Line 69: TYPE country_tbl IS TABLE OF fnd_territories_vl.territory_short_name%TYPE

65: TYPE country_code_tbl IS TABLE OF fnd_territories_vl.territory_code%TYPE
66: INDEX BY BINARY_INTEGER;
67: l_country_code_tbl country_code_tbl;
68:
69: TYPE country_tbl IS TABLE OF fnd_territories_vl.territory_short_name%TYPE
70: INDEX BY BINARY_INTEGER;
71: l_country_tbl country_tbl;
72:
73: TYPE region_tbl IS TABLE OF pa_locations.region%TYPE

Line 444: , fnd_territories_vl ter

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
446: , pa_advertised_open_req_v aor
447: WHERE asgn.assignment_id = p_search_criteria.assignment_id
448: AND asgn.min_resource_job_level <= p_search_criteria.min_job_level

Line 495: , fnd_territories_vl ter

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
497: , pa_advertised_open_req_v aor
498: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
499: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level

Line 546: , fnd_territories_vl ter

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
548: , pa_advertised_open_req_v aor
549: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
550: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level

Line 596: , fnd_territories_vl ter

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
598: , pa_advertised_open_req_v aor
599: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
600: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level

Line 641: , fnd_territories_vl ter

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
643: , pa_advertised_open_req_v aor
644: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
645: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level