APPS.PA_SEARCH_PVT dependencies on PER_COMPETENCE_ELEMENTS

Line 789: -- per_competence_elements pce,

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

Line 818: per_competence_elements pce,

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

Line 875: FROM per_competence_elements pce,

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

Line 1352: FROM per_competence_elements pce

1348: FORALL i IN l_assignment_id_tbl.FIRST .. l_assignment_id_tbl.LAST
1349: UPDATE pa_search_results_temp
1350: SET (mandatory_competence_count, optional_competence_count) =
1351: (SELECT nvl(sum(decode(mandatory,'Y',1,0)),0), nvl(sum(decode(mandatory,'N',1,0)),0)
1352: FROM per_competence_elements pce
1353: WHERE pce.object_name = 'OPEN_ASSIGNMENT'
1354: AND pce.object_id = l_assignment_id_tbl(i))
1355: WHERE assignment_id = l_assignment_id_tbl(i);
1356:

Line 1363: FROM per_competence_elements pce,

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

Line 1364: per_competence_elements pce2,

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