APPS.HR_COMPETENCE_ELEMENT_SWI dependencies on PER_COMPETENCE_ELEMENTS

Line 344: l_object_version_number per_competence_elements.object_version_number%TYPE;

340: -- Variables for IN/OUT parameters
341: --
342: -- Other variables
343: l_proc varchar2(72) := g_package ||'delete_competence_element';
344: l_object_version_number per_competence_elements.object_version_number%TYPE;
345:
346: cursor get_object_version_number(p_competence_element_id per_competence_elements.competence_element_id%TYPE) is
347: select object_version_number
348: from per_competence_elements

Line 346: cursor get_object_version_number(p_competence_element_id per_competence_elements.competence_element_id%TYPE) is

342: -- Other variables
343: l_proc varchar2(72) := g_package ||'delete_competence_element';
344: l_object_version_number per_competence_elements.object_version_number%TYPE;
345:
346: cursor get_object_version_number(p_competence_element_id per_competence_elements.competence_element_id%TYPE) is
347: select object_version_number
348: from per_competence_elements
349: where competence_element_id = p_competence_element_id;
350: Begin

Line 348: from per_competence_elements

344: l_object_version_number per_competence_elements.object_version_number%TYPE;
345:
346: cursor get_object_version_number(p_competence_element_id per_competence_elements.competence_element_id%TYPE) is
347: select object_version_number
348: from per_competence_elements
349: where competence_element_id = p_competence_element_id;
350: Begin
351: hr_utility.set_location(' Entering:' || l_proc,10);
352:

Line 1286: select person_id from per_competence_elements

1282: --
1283: CURSOR get_person_for_comp_element
1284: (p_comp_elt_id IN NUMBER)
1285: IS
1286: select person_id from per_competence_elements
1287: where competence_element_id = p_comp_elt_id;
1288:
1289: l_person_id NUMBER;
1290: l_attach_status varchar2(80);