APPS.HR_COMP_ELEMENT_OUTCOME_API dependencies on PER_COMPETENCE_OUTCOMES

Line 75: from per_competence_outcomes

71: where competence_element_id = p_competence_element_id;
72:
73: cursor csr_get_competence_id is
74: select competence_id
75: from per_competence_outcomes
76: where outcome_id = p_outcome_id;
77:
78: l_proc varchar2(72) := g_package||'create_element_outcome';
79: l_effective_date date;

Line 81: l_competence_id per_competence_outcomes.competence_id%TYPE;

77:
78: l_proc varchar2(72) := g_package||'create_element_outcome';
79: l_effective_date date;
80: l_boolean boolean;
81: l_competence_id per_competence_outcomes.competence_id%TYPE;
82: l_max_date_from date;
83:
84: --
85: -- Declare out parameters

Line 315: from per_competence_outcomes

311: -- Call update_competence_element to update the status to ACHIEVED
312: -- If all required outcome are achieved
313: --
314: select competence_id into l_competence_id
315: from per_competence_outcomes
316: where outcome_id = p_outcome_id;
317:
318: hr_utility.trace('l_competence_id : ' || l_competence_id);
319: