APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on PER_COMPETENCES

Line 557: RETURN per_competences_tl.name%type IS

553: -- ---------------------------------------------------------------------------
554:
555: FUNCTION get_competence_name
556: (p_competence_id in number)
557: RETURN per_competences_tl.name%type IS
558:
559: CURSOR csr_competence_name IS
560: SELECT name
561: FROM per_competences_tl

Line 561: FROM per_competences_tl

557: RETURN per_competences_tl.name%type IS
558:
559: CURSOR csr_competence_name IS
560: SELECT name
561: FROM per_competences_tl
562: WHERE competence_id = p_competence_id
563: AND language = userenv('LANG') ;
564:
565: l_name per_competences_tl.name%TYPE;

Line 565: l_name per_competences_tl.name%TYPE;

561: FROM per_competences_tl
562: WHERE competence_id = p_competence_id
563: AND language = userenv('LANG') ;
564:
565: l_name per_competences_tl.name%TYPE;
566:
567: BEGIN
568:
569: OPEN csr_competence_name;

Line 1553: per_competences_tl cpl,

1549: r2.step_value high_step_value,
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

Line 1653: per_competences_tl cpl,

1649: rtx1.name low_step_name,
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

Line 1759: per_competences_tl cpl,

1755: rtx1.name low_step_name,
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

Line 1872: per_competences_tl cpl,

1868: rtx1.name low_step_name,
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

Line 2263: per_competences_tl cpl,

2259: rtx1.name low_step_name,
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

Line 3472: ,per_competences pc

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
3476: AND prl.rating_level_id = rtx.rating_level_id

Line 3483: ,per_competences pc

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
3487: AND prl.rating_level_id = rtx.rating_level_id