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_SUIT_MATCH_UTIL_SS dependencies on PER_RATING_LEVELS

Line 19: select /+ leading(smtmp) index(pce, PER_COMPETENCE_ELEMENTS_FK7) index(r1, PER_RATING_LEVELS_PK) /

15: where smtmp.mandatory = (p_mandatory);
16:
17: -- declare global cursor for essential/desired match count
18: CURSOR csr_ess_des_match_count(p_person_id in number, p_mandatory in varchar2)IS
19: select /*+ leading(smtmp) index(pce, PER_COMPETENCE_ELEMENTS_FK7) index(r1, PER_RATING_LEVELS_PK) */
20: count(pce.competence_id)
21: FROM per_competence_elements pce,
22: per_suitmatch_comp smtmp,
23: per_rating_levels r1

Line 23: per_rating_levels r1

19: select /*+ leading(smtmp) index(pce, PER_COMPETENCE_ELEMENTS_FK7) index(r1, PER_RATING_LEVELS_PK) */
20: count(pce.competence_id)
21: FROM per_competence_elements pce,
22: per_suitmatch_comp smtmp,
23: per_rating_levels r1
24: where pce.competence_id = smtmp.competence_id
25: AND nvl(r1.step_value,-1) >= nvl(smtmp.min_step_value, -1)
26: AND pce.type = 'PERSONAL'
27: AND trunc(sysdate) BETWEEN pce.effective_date_from AND

Line 45: per_rating_levels r1,

41: ,p_mandatory in varchar2) IS
42: SELECT count(pcep.competence_id)
43: FROM per_competence_elements pce,
44: per_competence_elements pcep,
45: per_rating_levels r1,
46: per_rating_levels r2
47: WHERE pce.type = 'REQUIREMENT'
48: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
49: and nvl(pce.effective_date_to, trunc(sysdate))

Line 46: per_rating_levels r2

42: SELECT count(pcep.competence_id)
43: FROM per_competence_elements pce,
44: per_competence_elements pcep,
45: per_rating_levels r1,
46: per_rating_levels r2
47: WHERE pce.type = 'REQUIREMENT'
48: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
49: and nvl(pce.effective_date_to, trunc(sysdate))
50: AND pce.proficiency_level_id = r1.rating_level_id(+)

Line 87: SELECT /+ leading(smtmp) index(pcep, PER_COMPETENCE_ELEMENTS_FK7) index(r2, PER_RATING_LEVELS_PK) /

83: -- work opp coming from temp table
84: CURSOR csr_wp_tmp_ed_match_count(
85: p_person_id in number
86: ,p_mandatory in varchar2) IS
87: SELECT /*+ leading(smtmp) index(pcep, PER_COMPETENCE_ELEMENTS_FK7) index(r2, PER_RATING_LEVELS_PK) */
88: count(pcep.competence_id)
89: FROM per_suitmatch_comp smtmp,
90: per_competence_elements pcep,
91: per_rating_levels r2

Line 91: per_rating_levels r2

87: SELECT /*+ leading(smtmp) index(pcep, PER_COMPETENCE_ELEMENTS_FK7) index(r2, PER_RATING_LEVELS_PK) */
88: count(pcep.competence_id)
89: FROM per_suitmatch_comp smtmp,
90: per_competence_elements pcep,
91: per_rating_levels r2
92: WHERE pcep.person_id = p_person_id
93: AND smtmp.competence_id = pcep.competence_id
94: AND pcep.type = 'PERSONAL'
95: AND trunc(sysdate) BETWEEN pcep.effective_date_from AND

Line 111: SELECT /+ leading(ptmp) index(pce, PER_COMPETENCE_ELEMENTS_N1) index(r1, PER_RATING_LEVELS_PK) /

107: ,p_organization_id in number
108: ,p_job_id in number
109: ,p_position_id in number
110: ,p_mandatory in varchar2) IS
111: SELECT /*+ leading(ptmp) index(pce, PER_COMPETENCE_ELEMENTS_N1) index(r1, PER_RATING_LEVELS_PK) */
112: count(ptmp.competence_id)
113: FROM per_competence_elements pce,
114: per_suitmatch_person ptmp,
115: per_rating_levels r1

Line 115: per_rating_levels r1

111: SELECT /*+ leading(ptmp) index(pce, PER_COMPETENCE_ELEMENTS_N1) index(r1, PER_RATING_LEVELS_PK) */
112: count(ptmp.competence_id)
113: FROM per_competence_elements pce,
114: per_suitmatch_person ptmp,
115: per_rating_levels r1
116: WHERE pce.type = 'REQUIREMENT'
117: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
118: and nvl(pce.effective_date_to, trunc(sysdate))
119: AND pce.proficiency_level_id = r1.rating_level_id(+)

Line 228: per_rating_levels r1,

224: r2.step_value high_step_value,
225: pce.mandatory,
226: 'BUS' lookup_code
227: FROM per_competence_elements pce,
228: per_rating_levels r1,
229: per_rating_levels r2
230: WHERE pce.type = 'REQUIREMENT'
231: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
232: and nvl(pce.effective_date_to, trunc(sysdate))

Line 229: per_rating_levels r2

225: pce.mandatory,
226: 'BUS' lookup_code
227: FROM per_competence_elements pce,
228: per_rating_levels r1,
229: per_rating_levels r2
230: WHERE pce.type = 'REQUIREMENT'
231: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
232: and nvl(pce.effective_date_to, trunc(sysdate))
233: AND pce.proficiency_level_id = r1.rating_level_id(+)

Line 243: per_rating_levels r1,

239: r2.step_value high_step_value,
240: pce.mandatory,
241: 'ORG' lookup_code
242: FROM per_competence_elements pce,
243: per_rating_levels r1,
244: per_rating_levels r2
245: WHERE pce.type = 'REQUIREMENT'
246: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
247: and nvl(pce.effective_date_to, trunc(sysdate))

Line 244: per_rating_levels r2

240: pce.mandatory,
241: 'ORG' lookup_code
242: FROM per_competence_elements pce,
243: per_rating_levels r1,
244: per_rating_levels r2
245: WHERE pce.type = 'REQUIREMENT'
246: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
247: and nvl(pce.effective_date_to, trunc(sysdate))
248: AND pce.proficiency_level_id = r1.rating_level_id(+)

Line 258: per_rating_levels r1,

254: r2.step_value high_step_value,
255: pce.mandatory,
256: 'JOB' lookup_code
257: FROM per_competence_elements pce,
258: per_rating_levels r1,
259: per_rating_levels r2
260: WHERE pce.type = 'REQUIREMENT'
261: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
262: and nvl(pce.effective_date_to, trunc(sysdate))

Line 259: per_rating_levels r2

255: pce.mandatory,
256: 'JOB' lookup_code
257: FROM per_competence_elements pce,
258: per_rating_levels r1,
259: per_rating_levels r2
260: WHERE pce.type = 'REQUIREMENT'
261: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
262: and nvl(pce.effective_date_to, trunc(sysdate))
263: AND pce.proficiency_level_id = r1.rating_level_id(+)

Line 273: per_rating_levels r1,

269: r2.step_value high_step_value,
270: pce.mandatory,
271: 'POS' lookup_code
272: FROM per_competence_elements pce,
273: per_rating_levels r1,
274: per_rating_levels r2
275: WHERE pce.type = 'REQUIREMENT'
276: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
277: and nvl(pce.effective_date_to, trunc(sysdate))

Line 274: per_rating_levels r2

270: pce.mandatory,
271: 'POS' lookup_code
272: FROM per_competence_elements pce,
273: per_rating_levels r1,
274: per_rating_levels r2
275: WHERE pce.type = 'REQUIREMENT'
276: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
277: and nvl(pce.effective_date_to, trunc(sysdate))
278: AND pce.proficiency_level_id = r1.rating_level_id(+)