APPS.PA_SEARCH_PVT dependencies on PER_RATING_LEVELS

Line 790: -- per_rating_levels prl

786: -- SET (mandatory_competence_match,optional_competence_match)=
787: -- (SELECT /*+ ORDERED */nvl(sum(decode(pct.mandatory_flag,'Y',1,0)),0), nvl(sum(decode(pct.mandatory_flag,'N',1,0)),0)
788: -- FROM pa_competence_criteria_temp pct,
789: -- per_competence_elements pce,
790: -- per_rating_levels prl
791: -- WHERE pce.competence_id = pct.competence_id
792: -- AND pce.person_id = l_person_id_tbl(i)
793: -- AND pce.proficiency_level_id =
794: -- prl.rating_level_id(+)

Line 819: per_rating_levels prl

815: SET (mandatory_competence_match,optional_competence_match)=
816: (SELECT /*+ leading(PCE PCT ) use_nl(PCT) */nvl(sum(decode(pct.mandatory_flag,'Y',1,0)),0), nvl(sum(decode(pct.mandatory_flag,'N',1,0)),0) --Bug 12701655
817: FROM pa_competence_criteria_temp pct,
818: per_competence_elements pce,
819: per_rating_levels prl
820: WHERE (pct.competence_id <> -1 AND
821: pce.competence_id = pct.competence_id)
822: AND pce.person_id = l_person_id_tbl(i)
823: AND pce.proficiency_level_id =

Line 877: per_rating_levels prl

873: WHERE pct.competence_id = -1
874: AND EXISTS ( SELECT 'Y'
875: FROM per_competence_elements pce,
876: per_competences pc,
877: per_rating_levels prl
878: WHERE pce.person_id = l_person_id_tbl(i)
879: AND pce.competence_id = pc.competence_id
880: /*code added for bug 2932045*/
881:

Line 1365: per_rating_levels prl,

1361: SET (mandatory_competence_match,optional_competence_match)=
1362: (SELECT nvl(sum(decode(pce.mandatory,'Y',1,0)),0), nvl(sum(decode(pce.mandatory,'N',1,0)),0)
1363: FROM per_competence_elements pce,
1364: per_competence_elements pce2,
1365: per_rating_levels prl,
1366: per_rating_levels prl2
1367: WHERE pce.object_id = l_assignment_id_tbl(i)
1368: AND pce.object_name = 'OPEN_ASSIGNMENT'
1369: AND pce.proficiency_level_id = prl.rating_level_id(+)

Line 1366: per_rating_levels prl2

1362: (SELECT nvl(sum(decode(pce.mandatory,'Y',1,0)),0), nvl(sum(decode(pce.mandatory,'N',1,0)),0)
1363: FROM per_competence_elements pce,
1364: per_competence_elements pce2,
1365: per_rating_levels prl,
1366: per_rating_levels prl2
1367: WHERE pce.object_id = l_assignment_id_tbl(i)
1368: AND pce.object_name = 'OPEN_ASSIGNMENT'
1369: AND pce.proficiency_level_id = prl.rating_level_id(+)
1370: AND pce.competence_id = pce2.competence_id

Line 1694: FROM per_rating_levels

1690: fnd_file.put_line(FND_FILE.LOG,'about to get the rating level');
1691: END IF;
1692:
1693: SELECT step_value INTO PA_SEARCH_GLOB.g_competence_criteria(i).rating_level
1694: FROM per_rating_levels
1695: WHERE rating_level_id = l_competency_tbl(i).rating_level_id;
1696:
1697: IF p_debug_mode = 'Y' THEN
1698: fnd_file.put_line(FND_FILE.LOG,'got the rating level');