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.HR_WPM_MASS_APR_PUSH dependencies on PER_COMPETENCES

Line 109: NAME per_competences_vl.NAME%TYPE,

105: competence_id per_competence_elements.competence_id%TYPE,
106: competence_element_id per_competence_elements.competence_element_id%TYPE,
107: TYPE per_competence_elements.TYPE%TYPE,
108: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
109: NAME per_competences_vl.NAME%TYPE,
110: RANK NUMBER
111: );
112:
113: TYPE bus_rules_comps IS RECORD (

Line 114: NAME per_competences_vl.NAME%TYPE,

110: RANK NUMBER
111: );
112:
113: TYPE bus_rules_comps IS RECORD (
114: NAME per_competences_vl.NAME%TYPE,
115: competence_id per_competences.competence_id%TYPE,
116: competence_element_id per_competence_elements.competence_element_id%TYPE,
117: mandatory per_competence_elements.mandatory%TYPE,
118: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,

Line 115: competence_id per_competences.competence_id%TYPE,

111: );
112:
113: TYPE bus_rules_comps IS RECORD (
114: NAME per_competences_vl.NAME%TYPE,
115: competence_id per_competences.competence_id%TYPE,
116: competence_element_id per_competence_elements.competence_element_id%TYPE,
117: mandatory per_competence_elements.mandatory%TYPE,
118: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
119: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,

Line 129: competence_alias per_competences.competence_alias%TYPE,

125: enterprise_id per_competence_elements.enterprise_id%TYPE,
126: structure_type hr_lookups.meaning%TYPE,
127: read_only_attr NUMBER,
128: detail_attr NUMBER,
129: competence_alias per_competences.competence_alias%TYPE,
130: GLOBAL VARCHAR2 (1),
131: description per_competences.description%TYPE,
132: date_from per_competences.date_from%TYPE,
133: certification_required per_competences.certification_required%TYPE,

Line 131: description per_competences.description%TYPE,

127: read_only_attr NUMBER,
128: detail_attr NUMBER,
129: competence_alias per_competences.competence_alias%TYPE,
130: GLOBAL VARCHAR2 (1),
131: description per_competences.description%TYPE,
132: date_from per_competences.date_from%TYPE,
133: certification_required per_competences.certification_required%TYPE,
134: behavioural_indicator per_competences.behavioural_indicator%TYPE,
135: low_step_value per_rating_levels_vl.step_value%TYPE,

Line 132: date_from per_competences.date_from%TYPE,

128: detail_attr NUMBER,
129: competence_alias per_competences.competence_alias%TYPE,
130: GLOBAL VARCHAR2 (1),
131: description per_competences.description%TYPE,
132: date_from per_competences.date_from%TYPE,
133: certification_required per_competences.certification_required%TYPE,
134: behavioural_indicator per_competences.behavioural_indicator%TYPE,
135: low_step_value per_rating_levels_vl.step_value%TYPE,
136: low_step_name per_rating_levels_vl.NAME%TYPE,

Line 133: certification_required per_competences.certification_required%TYPE,

129: competence_alias per_competences.competence_alias%TYPE,
130: GLOBAL VARCHAR2 (1),
131: description per_competences.description%TYPE,
132: date_from per_competences.date_from%TYPE,
133: certification_required per_competences.certification_required%TYPE,
134: behavioural_indicator per_competences.behavioural_indicator%TYPE,
135: low_step_value per_rating_levels_vl.step_value%TYPE,
136: low_step_name per_rating_levels_vl.NAME%TYPE,
137: high_step_value per_rating_levels_vl.step_value%TYPE,

Line 134: behavioural_indicator per_competences.behavioural_indicator%TYPE,

130: GLOBAL VARCHAR2 (1),
131: description per_competences.description%TYPE,
132: date_from per_competences.date_from%TYPE,
133: certification_required per_competences.certification_required%TYPE,
134: behavioural_indicator per_competences.behavioural_indicator%TYPE,
135: low_step_value per_rating_levels_vl.step_value%TYPE,
136: low_step_name per_rating_levels_vl.NAME%TYPE,
137: high_step_value per_rating_levels_vl.step_value%TYPE,
138: high_step_name per_rating_levels_vl.NAME%TYPE,

Line 149: competence_id per_competences.competence_id%TYPE

145: TYPE sel_comp_tab IS TABLE OF bus_rules_comps
146: INDEX BY BINARY_INTEGER;
147:
148: TYPE competences_rc IS RECORD (
149: competence_id per_competences.competence_id%TYPE
150: );
151:
152: TYPE competences_tbl IS TABLE OF competences_rc
153: INDEX BY BINARY_INTEGER;

Line 731: per_competences_vl pc,

727: r2.step_value || ' - ' || r2.NAME
728: ) maximum_proficiency,
729: pce.TYPE
730: FROM per_competence_elements pce,
731: per_competences_vl pc,
732: hr_lookups hrl,
733: per_rating_levels_vl r1,
734: per_rating_levels_vl r2
735: WHERE pce.TYPE = 'REQUIREMENT'

Line 782: per_competences_vl pc,

778: r2.step_value || ' - ' || r2.NAME
779: ) maximum_proficiency,
780: pce.TYPE
781: FROM per_competence_elements pce,
782: per_competences_vl pc,
783: hr_lookups hrl,
784: per_rating_levels_vl r1,
785: per_rating_levels_vl r2
786: WHERE pce.TYPE = 'REQUIREMENT'

Line 833: per_competences_vl pc,

829: r2.step_value || ' - ' || r2.NAME
830: ) maximum_proficiency,
831: pce.TYPE
832: FROM per_competence_elements pce,
833: per_competences_vl pc,
834: hr_lookups hrl,
835: per_rating_levels_vl r1,
836: per_rating_levels_vl r2
837: WHERE pce.TYPE = 'REQUIREMENT'

Line 884: per_competences_vl pc,

880: r2.step_value || ' - ' || r2.NAME
881: ) maximum_proficiency,
882: pce.TYPE
883: FROM per_competence_elements pce,
884: per_competences_vl pc,
885: hr_lookups hrl,
886: per_rating_levels_vl r1,
887: per_rating_levels_vl r2
888: WHERE pce.TYPE = 'REQUIREMENT'

Line 1145: per_competences_vl c

1141: RANK () OVER (PARTITION BY ce.competence_id ORDER BY ce.competence_element_id)
1142: RANK
1143: FROM per_competence_elements a,
1144: per_competence_elements ce,
1145: per_competences_vl c
1146: WHERE a.assessment_type_id = p_assess_type_id
1147: AND a.TYPE = 'ASSESSMENT_GROUP'
1148: AND (NVL (c.date_from, TRUNC (SYSDATE)) <= TRUNC (SYSDATE))
1149: AND NVL (c.date_to, TRUNC (SYSDATE)) >= TRUNC (SYSDATE)