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 PER_COMPETENCES

Line 27: TYPE competence_name IS TABLE OF per_competences.name%TYPE

23: TYPE mandatory_flag IS TABLE OF pa_competence_criteria_temp.mandatory_flag%TYPE
24: INDEX BY BINARY_INTEGER;
25: l_mandatory_flag_tbl mandatory_flag;
26:
27: TYPE competence_name IS TABLE OF per_competences.name%TYPE
28: INDEX BY BINARY_INTEGER;
29: l_competence_name_tbl competence_name;
30:
31: l_mandatory_competence_count NUMBER:= 0;

Line 876: per_competences pc,

872: FROM pa_competence_criteria_temp pct
873: WHERE pct.competence_id = -1
874: AND EXISTS ( SELECT 'Y'
875: FROM per_competence_elements pce,
876: per_competences pc,
877: per_rating_levels prl
878: WHERE pce.person_id = l_person_id_tbl(i)
879: AND pce.competence_id = pc.competence_id
880: /*code added for bug 2932045*/