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 12: select /+ leading(smtmp) index(pce, PER_COMPETENCE_ELEMENTS_FK7) index(r1, PER_RATING_LEVELS_PK) /

8: where smtmp.mandatory = (p_mandatory);
9:
10: -- declare global cursor for essential/desired match count
11: CURSOR csr_ess_des_match_count(p_person_id in number, p_mandatory in varchar2)IS
12: select /*+ leading(smtmp) index(pce, PER_COMPETENCE_ELEMENTS_FK7) index(r1, PER_RATING_LEVELS_PK) */
13: count(pce.competence_id)
14: FROM per_competence_elements pce,
15: per_suitmatch_comp smtmp,
16: per_rating_levels r1

Line 16: per_rating_levels r1

12: select /*+ leading(smtmp) index(pce, PER_COMPETENCE_ELEMENTS_FK7) index(r1, PER_RATING_LEVELS_PK) */
13: count(pce.competence_id)
14: FROM per_competence_elements pce,
15: per_suitmatch_comp smtmp,
16: per_rating_levels r1
17: where pce.competence_id = smtmp.competence_id
18: AND nvl(r1.step_value,-1) >= nvl(smtmp.min_step_value, -1)
19: AND pce.type = 'PERSONAL'
20: AND trunc(sysdate) BETWEEN pce.effective_date_from AND

Line 38: per_rating_levels r1,

34: ,p_mandatory in varchar2) IS
35: SELECT count(pcep.competence_id)
36: FROM per_competence_elements pce,
37: per_competence_elements pcep,
38: per_rating_levels r1,
39: per_rating_levels r2
40: WHERE pce.type = 'REQUIREMENT'
41: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
42: and nvl(pce.effective_date_to, trunc(sysdate))

Line 39: per_rating_levels r2

35: SELECT count(pcep.competence_id)
36: FROM per_competence_elements pce,
37: per_competence_elements pcep,
38: per_rating_levels r1,
39: per_rating_levels r2
40: WHERE pce.type = 'REQUIREMENT'
41: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
42: and nvl(pce.effective_date_to, trunc(sysdate))
43: AND pce.proficiency_level_id = r1.rating_level_id(+)

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

76: -- work opp coming from temp table
77: CURSOR csr_wp_tmp_ed_match_count(
78: p_person_id in number
79: ,p_mandatory in varchar2) IS
80: SELECT /*+ leading(smtmp) index(pcep, PER_COMPETENCE_ELEMENTS_FK7) index(r2, PER_RATING_LEVELS_PK) */
81: count(pcep.competence_id)
82: FROM per_suitmatch_comp smtmp,
83: per_competence_elements pcep,
84: per_rating_levels r2

Line 84: per_rating_levels r2

80: SELECT /*+ leading(smtmp) index(pcep, PER_COMPETENCE_ELEMENTS_FK7) index(r2, PER_RATING_LEVELS_PK) */
81: count(pcep.competence_id)
82: FROM per_suitmatch_comp smtmp,
83: per_competence_elements pcep,
84: per_rating_levels r2
85: WHERE pcep.person_id = p_person_id
86: AND smtmp.competence_id = pcep.competence_id
87: AND pcep.type = 'PERSONAL'
88: AND trunc(sysdate) BETWEEN pcep.effective_date_from AND

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

100: ,p_organization_id in number
101: ,p_job_id in number
102: ,p_position_id in number
103: ,p_mandatory in varchar2) IS
104: SELECT /*+ leading(ptmp) index(pce, PER_COMPETENCE_ELEMENTS_N1) index(r1, PER_RATING_LEVELS_PK) */
105: count(ptmp.competence_id)
106: FROM per_competence_elements pce,
107: per_suitmatch_person ptmp,
108: per_rating_levels r1

Line 108: per_rating_levels r1

104: SELECT /*+ leading(ptmp) index(pce, PER_COMPETENCE_ELEMENTS_N1) index(r1, PER_RATING_LEVELS_PK) */
105: count(ptmp.competence_id)
106: FROM per_competence_elements pce,
107: per_suitmatch_person ptmp,
108: per_rating_levels r1
109: WHERE pce.type = 'REQUIREMENT'
110: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
111: and nvl(pce.effective_date_to, trunc(sysdate))
112: AND pce.proficiency_level_id = r1.rating_level_id(+)

Line 221: per_rating_levels r1,

217: r2.step_value high_step_value,
218: pce.mandatory,
219: 'BUS' lookup_code
220: FROM per_competence_elements pce,
221: per_rating_levels r1,
222: per_rating_levels r2
223: WHERE pce.type = 'REQUIREMENT'
224: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
225: and nvl(pce.effective_date_to, trunc(sysdate))

Line 222: per_rating_levels r2

218: pce.mandatory,
219: 'BUS' lookup_code
220: FROM per_competence_elements pce,
221: per_rating_levels r1,
222: per_rating_levels r2
223: WHERE pce.type = 'REQUIREMENT'
224: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
225: and nvl(pce.effective_date_to, trunc(sysdate))
226: AND pce.proficiency_level_id = r1.rating_level_id(+)

Line 236: per_rating_levels r1,

232: r2.step_value high_step_value,
233: pce.mandatory,
234: 'ORG' lookup_code
235: FROM per_competence_elements pce,
236: per_rating_levels r1,
237: per_rating_levels r2
238: WHERE pce.type = 'REQUIREMENT'
239: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
240: and nvl(pce.effective_date_to, trunc(sysdate))

Line 237: per_rating_levels r2

233: pce.mandatory,
234: 'ORG' lookup_code
235: FROM per_competence_elements pce,
236: per_rating_levels r1,
237: per_rating_levels r2
238: WHERE pce.type = 'REQUIREMENT'
239: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
240: and nvl(pce.effective_date_to, trunc(sysdate))
241: AND pce.proficiency_level_id = r1.rating_level_id(+)

Line 251: per_rating_levels r1,

247: r2.step_value high_step_value,
248: pce.mandatory,
249: 'JOB' lookup_code
250: FROM per_competence_elements pce,
251: per_rating_levels r1,
252: per_rating_levels r2
253: WHERE pce.type = 'REQUIREMENT'
254: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
255: and nvl(pce.effective_date_to, trunc(sysdate))

Line 252: per_rating_levels r2

248: pce.mandatory,
249: 'JOB' lookup_code
250: FROM per_competence_elements pce,
251: per_rating_levels r1,
252: per_rating_levels r2
253: WHERE pce.type = 'REQUIREMENT'
254: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
255: and nvl(pce.effective_date_to, trunc(sysdate))
256: AND pce.proficiency_level_id = r1.rating_level_id(+)

Line 266: per_rating_levels r1,

262: r2.step_value high_step_value,
263: pce.mandatory,
264: 'POS' lookup_code
265: FROM per_competence_elements pce,
266: per_rating_levels r1,
267: per_rating_levels r2
268: WHERE pce.type = 'REQUIREMENT'
269: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
270: and nvl(pce.effective_date_to, trunc(sysdate))

Line 267: per_rating_levels r2

263: pce.mandatory,
264: 'POS' lookup_code
265: FROM per_competence_elements pce,
266: per_rating_levels r1,
267: per_rating_levels r2
268: WHERE pce.type = 'REQUIREMENT'
269: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
270: and nvl(pce.effective_date_to, trunc(sysdate))
271: AND pce.proficiency_level_id = r1.rating_level_id(+)