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_CANDIDATES

Line 1539: TYPE candidate_id_tbl IS TABLE OF pa_candidates.candidate_id%TYPE

1535: TYPE resource_id_tbl IS TABLE OF pa_resources_denorm.resource_id%TYPE
1536: INDEX BY BINARY_INTEGER;
1537: l_resource_id_tbl resource_id_tbl;
1538:
1539: TYPE candidate_id_tbl IS TABLE OF pa_candidates.candidate_id%TYPE
1540: INDEX BY BINARY_INTEGER;
1541: l_candidate_id_tbl candidate_id_tbl;
1542:
1543: l_competency_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;

Line 1781: FROM pa_candidates cand,

1777: fnd_file.put_line(FND_FILE.LOG,'about to bulk collect the previous system nominated / qualified candidates who will NOT be system nominated in current run.');
1778: END IF;
1779:
1780: SELECT candidate_id BULK COLLECT INTO l_candidate_id_tbl
1781: FROM pa_candidates cand,
1782: pa_project_statuses ps
1783: WHERE assignment_id = PA_SEARCH_GLOB.g_search_criteria.assignment_id
1784: AND cand.status_code = ps.project_status_code
1785: AND ps.status_type = 'CANDIDATE'