eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_SEARCH_PVT dependencies on PA_ADVERTISED_OPEN_REQ_V

Line 446: , pa_advertised_open_req_v aor

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
449: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level
450: AND asgn.project_role_id = nvl(p_search_criteria.role_id, asgn.project_role_id)

Line 497: , pa_advertised_open_req_v aor

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
500: AND asgn.project_role_id = p_search_criteria.role_id
501: AND asgn.start_date >= p_search_criteria.start_date

Line 548: , pa_advertised_open_req_v aor

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
551: AND asgn.project_role_id = p_search_criteria.role_id
552: AND asgn.start_date >= p_search_criteria.start_date

Line 598: , pa_advertised_open_req_v aor

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
601: AND asgn.project_role_id = p_search_criteria.role_id
602: AND asgn.start_date >= p_search_criteria.start_date

Line 643: , pa_advertised_open_req_v aor

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
646: AND asgn.start_date >= p_search_criteria.start_date
647: AND asgn.start_date <= p_search_criteria.end_date