APPS.PA_HR_COMPETENCE_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30

        SELECT rating_level_id
        FROM per_competence_levels_v
        WHERE competence_id = p_competence_id
        AND step_value = p_rating_level;

Line: 38

          SELECT rating_level_id
          INTO x_rating_level_id
          FROM per_competence_levels_v
          WHERE competence_id = p_competence_id
          AND rating_level_id = p_rating_level_id;

Line: 78

            SELECT rating_level_id
            INTO x_rating_level_id
            FROM per_competence_levels_v
            WHERE competence_id = p_competence_id
            AND step_value = p_rating_level;

Line: 121

        SELECT competence_id
        FROM per_competences
        WHERE name = p_competence_name;

Line: 128

          SELECT competence_id
          INTO  x_competence_id
          FROM  per_competences
          WHERE competence_id = p_competence_id;

Line: 166

          SELECT competence_id
          INTO x_competence_id
          FROM per_competences
          WHERE competence_alias = p_competence_alias;

Line: 172

            SELECT competence_id
            INTO x_competence_id
            FROM per_competences
            WHERE name = p_competence_name;

Line: 248

SELECT
       pce.object_id,
       pce.competence_id,
       pce.proficiency_level_id rating_level_id,
       pce.competence_element_id,
       pce.rowid,
       pce.mandatory,
       pc.name      ,
       pc.competence_alias     ,
       Decode(pc.business_group_id ,NULL, 'Y','N') global_flag,
       pce.object_version_number
FROM
	per_competence_elements pce,
	per_competences pc
WHERE  pce.object_name = p_object_name
AND    pce.object_id   = p_object_id
AND    pce.competence_id = pc.competence_id;

Line: 267

SELECT
       pce.object_id,
       pce.competence_id,
       pce.proficiency_level_id rating_level_id,
       pce.competence_element_id,
       pce.rowid,
       pce.mandatory,
       pc.name      ,
       pc.competence_alias     ,
       Decode(pc.business_group_id ,NULL, 'Y','N') global_flag,
       pce.object_version_number
FROM   per_competence_elements pce,
       per_competences pc
WHERE  job_id = p_object_id
AND    pce.competence_id = pc.competence_id;

Line: 366

SELECT
       pce.person_id,
       pce.competence_id,
       pce.proficiency_level_id rating_level_id,
       pce.competence_element_id,
       pce.rowid,
       pce.mandatory,
       pc.name      ,
       pc.competence_alias     ,
       Decode(pc.business_group_id ,NULL, 'Y','N') global_flag,
       pce.object_version_number
FROM
	per_competence_elements pce,
	per_competences pc
WHERE  pce.person_id   = p_person_id
AND    pce.competence_id = pc.competence_id;

Line: 438

    SELECT 'x' INTO l_dummy
    FROM per_competence_elements
    WHERE object_id = p_object_id
    AND   object_name = p_object_name
    AND   competence_id = p_competence_id ;

Line: 468

    SELECT comp.name,
           comp.competence_alias,
           rl.step_value
    BULK COLLECT INTO
           l_competence_name,
           l_competence_alias,
           l_competence_level
    FROM  PER_COMPETENCE_ELEMENTS comp_ele,
          PER_COMPETENCES comp,
          PER_RATING_LEVELS rl
    WHERE comp_ele.competence_id        = comp.competence_id
    AND   comp_ele.person_id            = p_person_id
    AND   comp_ele.proficiency_level_id = rl.rating_level_id (+);

Line: 518

    SELECT count(*)
    INTO   l_count
    FROM   PER_COMPETENCE_ELEMENTS
    WHERE  person_id = p_person_id;

Line: 531

FUNCTION Get_Res_Comp_Last_Updated
   (p_person_id         IN      pa_resources_denorm.person_id%TYPE)
   RETURN DATE  IS
l_date DATE;

Line: 536

    SELECT MAX(last_update_date)
    INTO   l_date
    FROM   PER_COMPETENCE_ELEMENTS
    WHERE  person_id = p_person_id;

Line: 547

END Get_Res_Comp_Last_Updated;

Line: 562

    SELECT competence_alias,
           competence_name,
           rating_level_value
    BULK COLLECT INTO
           l_competence_alias,
           l_competence_name,
           l_competence_level
    FROM   pa_open_asgmt_competences_v
    WHERE  assignment_id = p_assignment_id;