APPS.HR_PUMP_GET dependencies on PER_COMPETENCES

Line 5051: FROM per_competences_vl

5047: IF p_business_group_id is null THEN
5048:
5049: SELECT competence_id
5050: INTO l_competence_id
5051: FROM per_competences_vl
5052: WHERE name = p_competence_name
5053: AND business_group_id is null;
5054:
5055: ELSE

Line 5059: FROM per_competences_vl

5055: ELSE
5056:
5057: SELECT competence_id
5058: INTO l_competence_id
5059: FROM per_competences_vl
5060: WHERE name = p_competence_name
5061: AND business_group_id = p_business_group_id;
5062:
5063: END IF;

Line 5105: FROM per_competences_vl

5101: IF p_business_group_id is null THEN
5102:
5103: SELECT object_version_number
5104: INTO l_cpn_ovn
5105: FROM per_competences_vl
5106: WHERE name = p_competence_name
5107: AND business_group_id is null;
5108:
5109: ELSE

Line 5113: FROM per_competences_vl

5109: ELSE
5110:
5111: SELECT object_version_number
5112: INTO l_cpn_ovn
5113: FROM per_competences_vl
5114: WHERE name = p_competence_name
5115: AND business_group_id = p_business_group_id;
5116:
5117: END IF;

Line 5352: ,per_competences CPN

5348:
5349: SELECT competence_element_id
5350: INTO l_competence_element_id
5351: FROM per_competence_elements CEL
5352: ,per_competences CPN
5353: WHERE
5354: CEL.type = 'PERSONAL'
5355: and CPN.name = p_competence_name
5356: and CEL.competence_id = CPN.competence_id