APPS.PA_SEARCH_PVT dependencies on PA_LOCATIONS

Line 73: TYPE region_tbl IS TABLE OF pa_locations.region%TYPE

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
74: INDEX BY BINARY_INTEGER;
75: l_region_tbl region_tbl;
76:
77: TYPE city_tbl IS TABLE OF pa_locations.city%TYPE

Line 77: TYPE city_tbl IS TABLE OF pa_locations.city%TYPE

73: TYPE region_tbl IS TABLE OF pa_locations.region%TYPE
74: INDEX BY BINARY_INTEGER;
75: l_region_tbl region_tbl;
76:
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

Line 435: , pa_locations loc

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

Line 486: , pa_locations loc

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

Line 537: , pa_locations loc

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

Line 587: , pa_locations loc

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

Line 632: , pa_locations loc

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