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

Line 533: RETURN per_rating_levels.step_value%TYPE IS

529: -- ---------------------------------------------------------------------------
530:
531: FUNCTION get_step_value
532: (p_rating_level_id in number)
533: RETURN per_rating_levels.step_value%TYPE IS
534:
535: CURSOR csr_step_value IS
536: SELECT step_value
537: FROM per_competence_levels_v

Line 540: l_step_value per_rating_levels.step_value%TYPE;

536: SELECT step_value
537: FROM per_competence_levels_v
538: WHERE rating_level_id = p_rating_level_id;
539:
540: l_step_value per_rating_levels.step_value%TYPE;
541:
542: BEGIN
543:
544: OPEN csr_step_value;

Line 1554: per_rating_levels r1,

1550: rtx1.name low_step_name,
1551: rtx2.name high_step_name
1552: FROM per_competence_elements pce,
1553: per_competences_tl cpl,
1554: per_rating_levels r1,
1555: per_rating_levels r2,
1556: per_rating_levels_tl rtx1,
1557: per_rating_levels_tl rtx2
1558: WHERE pce.ENTERPRISE_ID = p_core_id

Line 1555: per_rating_levels r2,

1551: rtx2.name high_step_name
1552: FROM per_competence_elements pce,
1553: per_competences_tl cpl,
1554: per_rating_levels r1,
1555: per_rating_levels r2,
1556: per_rating_levels_tl rtx1,
1557: per_rating_levels_tl rtx2
1558: WHERE pce.ENTERPRISE_ID = p_core_id
1559: AND pce.type = 'REQUIREMENT'

Line 1556: per_rating_levels_tl rtx1,

1552: FROM per_competence_elements pce,
1553: per_competences_tl cpl,
1554: per_rating_levels r1,
1555: per_rating_levels r2,
1556: per_rating_levels_tl rtx1,
1557: per_rating_levels_tl rtx2
1558: WHERE pce.ENTERPRISE_ID = p_core_id
1559: AND pce.type = 'REQUIREMENT'
1560: AND pce.organization_id IS null

Line 1557: per_rating_levels_tl rtx2

1553: per_competences_tl cpl,
1554: per_rating_levels r1,
1555: per_rating_levels r2,
1556: per_rating_levels_tl rtx1,
1557: per_rating_levels_tl rtx2
1558: WHERE pce.ENTERPRISE_ID = p_core_id
1559: AND pce.type = 'REQUIREMENT'
1560: AND pce.organization_id IS null
1561: AND pce.job_id IS null

Line 1654: per_rating_levels r1,

1650: r2.step_value high_step_value,
1651: rtx2.name high_step_name
1652: FROM per_competence_elements pce,
1653: per_competences_tl cpl,
1654: per_rating_levels r1,
1655: per_rating_levels r2,
1656: per_rating_levels_tl rtx1,
1657: per_rating_levels_tl rtx2
1658: WHERE pce.organization_id = p_org_id

Line 1655: per_rating_levels r2,

1651: rtx2.name high_step_name
1652: FROM per_competence_elements pce,
1653: per_competences_tl cpl,
1654: per_rating_levels r1,
1655: per_rating_levels r2,
1656: per_rating_levels_tl rtx1,
1657: per_rating_levels_tl rtx2
1658: WHERE pce.organization_id = p_org_id
1659: AND pce.type = 'REQUIREMENT'

Line 1656: per_rating_levels_tl rtx1,

1652: FROM per_competence_elements pce,
1653: per_competences_tl cpl,
1654: per_rating_levels r1,
1655: per_rating_levels r2,
1656: per_rating_levels_tl rtx1,
1657: per_rating_levels_tl rtx2
1658: WHERE pce.organization_id = p_org_id
1659: AND pce.type = 'REQUIREMENT'
1660: AND p_effective_date BETWEEN pce.effective_date_from AND

Line 1657: per_rating_levels_tl rtx2

1653: per_competences_tl cpl,
1654: per_rating_levels r1,
1655: per_rating_levels r2,
1656: per_rating_levels_tl rtx1,
1657: per_rating_levels_tl rtx2
1658: WHERE pce.organization_id = p_org_id
1659: AND pce.type = 'REQUIREMENT'
1660: AND p_effective_date BETWEEN pce.effective_date_from AND
1661: NVL(pce.effective_date_to, p_effective_date)

Line 1760: per_rating_levels r1,

1756: r2.step_value high_step_value,
1757: rtx2.name high_step_name
1758: FROM per_competence_elements pce,
1759: per_competences_tl cpl,
1760: per_rating_levels r1,
1761: per_rating_levels r2,
1762: per_rating_levels_tl rtx1,
1763: per_rating_levels_tl rtx2
1764: WHERE pce.job_id = p_job_id

Line 1761: per_rating_levels r2,

1757: rtx2.name high_step_name
1758: FROM per_competence_elements pce,
1759: per_competences_tl cpl,
1760: per_rating_levels r1,
1761: per_rating_levels r2,
1762: per_rating_levels_tl rtx1,
1763: per_rating_levels_tl rtx2
1764: WHERE pce.job_id = p_job_id
1765: AND (pce.valid_grade_id IS null

Line 1762: per_rating_levels_tl rtx1,

1758: FROM per_competence_elements pce,
1759: per_competences_tl cpl,
1760: per_rating_levels r1,
1761: per_rating_levels r2,
1762: per_rating_levels_tl rtx1,
1763: per_rating_levels_tl rtx2
1764: WHERE pce.job_id = p_job_id
1765: AND (pce.valid_grade_id IS null
1766: -- OR pce.valid_grade_id = p_grade_id)

Line 1763: per_rating_levels_tl rtx2

1759: per_competences_tl cpl,
1760: per_rating_levels r1,
1761: per_rating_levels r2,
1762: per_rating_levels_tl rtx1,
1763: per_rating_levels_tl rtx2
1764: WHERE pce.job_id = p_job_id
1765: AND (pce.valid_grade_id IS null
1766: -- OR pce.valid_grade_id = p_grade_id)
1767: OR pce.valid_grade_id in (select pvg.valid_grade_id

Line 1873: per_rating_levels r1,

1869: r2.step_value high_step_value,
1870: rtx2.name high_step_name
1871: FROM per_competence_elements pce,
1872: per_competences_tl cpl,
1873: per_rating_levels r1,
1874: per_rating_levels r2,
1875: per_rating_levels_tl rtx1,
1876: per_rating_levels_tl rtx2
1877: WHERE pce.position_id = p_pos_id

Line 1874: per_rating_levels r2,

1870: rtx2.name high_step_name
1871: FROM per_competence_elements pce,
1872: per_competences_tl cpl,
1873: per_rating_levels r1,
1874: per_rating_levels r2,
1875: per_rating_levels_tl rtx1,
1876: per_rating_levels_tl rtx2
1877: WHERE pce.position_id = p_pos_id
1878: AND (pce.valid_grade_id IS null

Line 1875: per_rating_levels_tl rtx1,

1871: FROM per_competence_elements pce,
1872: per_competences_tl cpl,
1873: per_rating_levels r1,
1874: per_rating_levels r2,
1875: per_rating_levels_tl rtx1,
1876: per_rating_levels_tl rtx2
1877: WHERE pce.position_id = p_pos_id
1878: AND (pce.valid_grade_id IS null
1879: -- OR pce.valid_grade_id = p_grade_id)

Line 1876: per_rating_levels_tl rtx2

1872: per_competences_tl cpl,
1873: per_rating_levels r1,
1874: per_rating_levels r2,
1875: per_rating_levels_tl rtx1,
1876: per_rating_levels_tl rtx2
1877: WHERE pce.position_id = p_pos_id
1878: AND (pce.valid_grade_id IS null
1879: -- OR pce.valid_grade_id = p_grade_id)
1880: OR pce.valid_grade_id in (select pvg.valid_grade_id

Line 2264: per_rating_levels r1,

2260: r2.step_value high_step_value,
2261: rtx2.name high_step_name
2262: FROM per_competence_elements pce,
2263: per_competences_tl cpl,
2264: per_rating_levels r1,
2265: per_rating_levels r2,
2266: per_rating_levels_tl rtx1,
2267: per_rating_levels_tl rtx2
2268: WHERE pce.person_id = p_person_id

Line 2265: per_rating_levels r2,

2261: rtx2.name high_step_name
2262: FROM per_competence_elements pce,
2263: per_competences_tl cpl,
2264: per_rating_levels r1,
2265: per_rating_levels r2,
2266: per_rating_levels_tl rtx1,
2267: per_rating_levels_tl rtx2
2268: WHERE pce.person_id = p_person_id
2269: AND pce.type = 'PERSONAL'

Line 2266: per_rating_levels_tl rtx1,

2262: FROM per_competence_elements pce,
2263: per_competences_tl cpl,
2264: per_rating_levels r1,
2265: per_rating_levels r2,
2266: per_rating_levels_tl rtx1,
2267: per_rating_levels_tl rtx2
2268: WHERE pce.person_id = p_person_id
2269: AND pce.type = 'PERSONAL'
2270: AND p_effective_date BETWEEN pce.effective_date_from AND

Line 2267: per_rating_levels_tl rtx2

2263: per_competences_tl cpl,
2264: per_rating_levels r1,
2265: per_rating_levels r2,
2266: per_rating_levels_tl rtx1,
2267: per_rating_levels_tl rtx2
2268: WHERE pce.person_id = p_person_id
2269: AND pce.type = 'PERSONAL'
2270: AND p_effective_date BETWEEN pce.effective_date_from AND
2271: NVL(pce.effective_date_to, p_effective_date)

Line 3471: FROM per_rating_levels prl

3467: ,p_count out nocopy number) IS
3468:
3469: CURSOR csr_rating_level_by_scale IS
3470: SELECT prl.rating_level_id, prl.step_value, rtx.name
3471: FROM per_rating_levels prl
3472: ,per_competences pc
3473: ,per_rating_levels_tl rtx
3474: WHERE pc.competence_id = p_competence_id
3475: AND pc.rating_scale_id = prl.rating_scale_id

Line 3473: ,per_rating_levels_tl rtx

3469: CURSOR csr_rating_level_by_scale IS
3470: SELECT prl.rating_level_id, prl.step_value, rtx.name
3471: FROM per_rating_levels prl
3472: ,per_competences pc
3473: ,per_rating_levels_tl rtx
3474: WHERE pc.competence_id = p_competence_id
3475: AND pc.rating_scale_id = prl.rating_scale_id
3476: AND prl.rating_level_id = rtx.rating_level_id
3477: AND rtx.language = userenv('LANG')

Line 3482: FROM per_rating_levels prl

3478: ORDER BY step_value;
3479:
3480: CURSOR csr_rating_level_by_competence IS
3481: SELECT prl.rating_level_id, prl.step_value, rtx.name
3482: FROM per_rating_levels prl
3483: ,per_competences pc
3484: ,per_rating_levels_tl rtx
3485: WHERE pc.competence_id = p_competence_id
3486: AND pc.competence_id = prl.competence_id

Line 3484: ,per_rating_levels_tl rtx

3480: CURSOR csr_rating_level_by_competence IS
3481: SELECT prl.rating_level_id, prl.step_value, rtx.name
3482: FROM per_rating_levels prl
3483: ,per_competences pc
3484: ,per_rating_levels_tl rtx
3485: WHERE pc.competence_id = p_competence_id
3486: AND pc.competence_id = prl.competence_id
3487: AND prl.rating_level_id = rtx.rating_level_id
3488: AND rtx.language = userenv('LANG')