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 436: , fnd_territories_vl ter

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
438: , pa_advertised_open_req_v aor
439: WHERE asgn.assignment_id = p_search_criteria.assignment_id
440: AND asgn.min_resource_job_level <= p_search_criteria.min_job_level

Line 487: , fnd_territories_vl ter

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
489: , pa_advertised_open_req_v aor
490: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
491: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level

Line 538: , fnd_territories_vl ter

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
540: , pa_advertised_open_req_v aor
541: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
542: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level

Line 588: , fnd_territories_vl ter

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
590: , pa_advertised_open_req_v aor
591: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
592: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level

Line 633: , fnd_territories_vl ter

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
635: , pa_advertised_open_req_v aor
636: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
637: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level