DBA Data[Home] [Help]

APPS.PA_SEARCH_PVT dependencies on PA_CANDIDATES

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

1485: TYPE resource_id_tbl IS TABLE OF pa_resources_denorm.resource_id%TYPE
1486: INDEX BY BINARY_INTEGER;
1487: l_resource_id_tbl resource_id_tbl;
1488:
1489: TYPE candidate_id_tbl IS TABLE OF pa_candidates.candidate_id%TYPE
1490: INDEX BY BINARY_INTEGER;
1491: l_candidate_id_tbl candidate_id_tbl;
1492:
1493: l_competency_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;

Line 1730: FROM pa_candidates cand,

1726: 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.');
1727: END IF;
1728:
1729: SELECT candidate_id BULK COLLECT INTO l_candidate_id_tbl
1730: FROM pa_candidates cand,
1731: pa_project_statuses ps
1732: WHERE assignment_id = PA_SEARCH_GLOB.g_search_criteria.assignment_id
1733: AND cand.status_code = ps.project_status_code
1734: AND ps.status_type = 'CANDIDATE'