APPS.PA_SEARCH_PVT dependencies on PER_RATING_LEVELS

Line 782: -- per_rating_levels prl

778: -- SET (mandatory_competence_match,optional_competence_match)=
779: -- (SELECT /*+ ORDERED */nvl(sum(decode(pct.mandatory_flag,'Y',1,0)),0), nvl(sum(decode(pct.mandatory_flag,'N',1,0)),0)
780: -- FROM pa_competence_criteria_temp pct,
781: -- per_competence_elements pce,
782: -- per_rating_levels prl
783: -- WHERE pce.competence_id = pct.competence_id
784: -- AND pce.person_id = l_person_id_tbl(i)
785: -- AND pce.proficiency_level_id =
786: -- prl.rating_level_id(+)

Line 810: per_rating_levels prl

806: SET (mandatory_competence_match,optional_competence_match)=
807: (SELECT /*+ ORDERED */nvl(sum(decode(pct.mandatory_flag,'Y',1,0)),0), nvl(sum(decode(pct.mandatory_flag,'N',1,0)),0)
808: FROM pa_competence_criteria_temp pct,
809: per_competence_elements pce,
810: per_rating_levels prl
811: WHERE (pct.competence_id <> -1 AND
812: pce.competence_id = pct.competence_id)
813: AND pce.person_id = l_person_id_tbl(i)
814: AND pce.proficiency_level_id =

Line 861: per_rating_levels prl

857: WHERE pct.competence_id = -1
858: AND EXISTS ( SELECT 'Y'
859: FROM per_competence_elements pce,
860: per_competences pc,
861: per_rating_levels prl
862: WHERE pce.person_id = l_person_id_tbl(i)
863: AND pce.competence_id = pc.competence_id
864: /*code added for bug 2932045*/
865:

Line 1315: per_rating_levels prl,

1311: SET (mandatory_competence_match,optional_competence_match)=
1312: (SELECT nvl(sum(decode(pce.mandatory,'Y',1,0)),0), nvl(sum(decode(pce.mandatory,'N',1,0)),0)
1313: FROM per_competence_elements pce,
1314: per_competence_elements pce2,
1315: per_rating_levels prl,
1316: per_rating_levels prl2
1317: WHERE pce.object_id = l_assignment_id_tbl(i)
1318: AND pce.object_name = 'OPEN_ASSIGNMENT'
1319: AND pce.proficiency_level_id = prl.rating_level_id(+)

Line 1316: per_rating_levels prl2

1312: (SELECT nvl(sum(decode(pce.mandatory,'Y',1,0)),0), nvl(sum(decode(pce.mandatory,'N',1,0)),0)
1313: FROM per_competence_elements pce,
1314: per_competence_elements pce2,
1315: per_rating_levels prl,
1316: per_rating_levels prl2
1317: WHERE pce.object_id = l_assignment_id_tbl(i)
1318: AND pce.object_name = 'OPEN_ASSIGNMENT'
1319: AND pce.proficiency_level_id = prl.rating_level_id(+)
1320: AND pce.competence_id = pce2.competence_id

Line 1643: FROM per_rating_levels

1639: fnd_file.put_line(FND_FILE.LOG,'about to get the rating level');
1640: END IF;
1641:
1642: SELECT step_value INTO PA_SEARCH_GLOB.g_competence_criteria(i).rating_level
1643: FROM per_rating_levels
1644: WHERE rating_level_id = l_competency_tbl(i).rating_level_id;
1645:
1646: IF p_debug_mode = 'Y' THEN
1647: fnd_file.put_line(FND_FILE.LOG,'got the rating level');