APPS.HR_PUMP_GET dependencies on PER_COMPETENCES

Line 5078: FROM per_competences_vl

5074: IF p_business_group_id is null THEN
5075:
5076: SELECT competence_id
5077: INTO l_competence_id
5078: FROM per_competences_vl
5079: WHERE name = p_competence_name
5080: AND business_group_id is null;
5081:
5082: ELSE

Line 5086: FROM per_competences_vl

5082: ELSE
5083:
5084: SELECT competence_id
5085: INTO l_competence_id
5086: FROM per_competences_vl
5087: WHERE name = p_competence_name
5088: AND business_group_id = p_business_group_id;
5089:
5090: END IF;

Line 5132: FROM per_competences_vl

5128: IF p_business_group_id is null THEN
5129:
5130: SELECT object_version_number
5131: INTO l_cpn_ovn
5132: FROM per_competences_vl
5133: WHERE name = p_competence_name
5134: AND business_group_id is null;
5135:
5136: ELSE

Line 5140: FROM per_competences_vl

5136: ELSE
5137:
5138: SELECT object_version_number
5139: INTO l_cpn_ovn
5140: FROM per_competences_vl
5141: WHERE name = p_competence_name
5142: AND business_group_id = p_business_group_id;
5143:
5144: END IF;

Line 5379: ,per_competences CPN

5375:
5376: SELECT competence_element_id
5377: INTO l_competence_element_id
5378: FROM per_competence_elements CEL
5379: ,per_competences CPN
5380: WHERE
5381: CEL.type = 'PERSONAL'
5382: and CPN.name = p_competence_name
5383: and CEL.competence_id = CPN.competence_id