APPS.PA_SEARCH_PVT dependencies on PER_COMPETENCE_ELEMENTS

Line 781: -- per_competence_elements pce,

777: -- UPDATE pa_search_results_temp
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 =

Line 809: per_competence_elements pce,

805: UPDATE pa_search_results_temp
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)

Line 859: FROM per_competence_elements pce,

855: (nvl(sum(decode(pct.mandatory_flag,'N',1,0)),0) + nvl(optional_competence_match, 0))
856: FROM pa_competence_criteria_temp pct
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

Line 1302: FROM per_competence_elements pce

1298: FORALL i IN l_assignment_id_tbl.FIRST .. l_assignment_id_tbl.LAST
1299: UPDATE pa_search_results_temp
1300: SET (mandatory_competence_count, optional_competence_count) =
1301: (SELECT nvl(sum(decode(mandatory,'Y',1,0)),0), nvl(sum(decode(mandatory,'N',1,0)),0)
1302: FROM per_competence_elements pce
1303: WHERE pce.object_name = 'OPEN_ASSIGNMENT'
1304: AND pce.object_id = l_assignment_id_tbl(i))
1305: WHERE assignment_id = l_assignment_id_tbl(i);
1306:

Line 1313: FROM per_competence_elements pce,

1309: FORALL i IN l_assignment_id_tbl.FIRST .. l_assignment_id_tbl.LAST
1310: UPDATE pa_search_results_temp
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)

Line 1314: per_competence_elements pce2,

1310: UPDATE pa_search_results_temp
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'