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 438: , pa_advertised_open_req_v aor

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

Line 489: , pa_advertised_open_req_v aor

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

Line 540: , pa_advertised_open_req_v aor

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

Line 590: , pa_advertised_open_req_v aor

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

Line 635: , pa_advertised_open_req_v aor

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