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 443: , pa_locations loc

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

Line 494: , pa_locations loc

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

Line 545: , pa_locations loc

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

Line 595: , pa_locations loc

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

Line 640: , pa_locations loc

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