APPS.HR_COMPLETE_APPRAISAL_SS dependencies on PER_COMP_ELEMENT_OUTCOMES

Line 504: From per_comp_element_outcomes ceo,

500: ceo.INFORMATION4, ceo.INFORMATION5, ceo.INFORMATION6, ceo.INFORMATION7, ceo.INFORMATION8,
501: ceo.INFORMATION9, ceo.INFORMATION10, ceo.INFORMATION11, ceo.INFORMATION12,
502: ceo.INFORMATION13, ceo.INFORMATION14, ceo.INFORMATION15, ceo.INFORMATION16,
503: ceo.INFORMATION17, ceo.INFORMATION18, ceo.INFORMATION19, ceo.INFORMATION20
504: From per_comp_element_outcomes ceo,
505: per_competence_outcomes co
506: Where ceo.Competence_element_id = p_competence_element_id
507: AND co.outcome_id = ceo.outcome_id
508: AND co.DATE_FROM <= ceo.DATE_FROM

Line 523: l_out_from_date per_comp_element_outcomes.DATE_FROM%type;

519: error_message varchar2(500) default null;
520: assessed_comps number default 0;
521: l_comp_log varchar2(32767);
522:
523: l_out_from_date per_comp_element_outcomes.DATE_FROM%type;
524: l_out_ovn per_comp_element_outcomes.OBJECT_VERSION_NUMBER%type;
525: l_comp_ele_out_id per_comp_element_outcomes.COMP_ELEMENT_OUTCOME_ID%type;
526: l_comp_status per_competence_elements.status%type;
527: l_achieved_date per_competence_elements.ACHIEVED_DATE%type;

Line 524: l_out_ovn per_comp_element_outcomes.OBJECT_VERSION_NUMBER%type;

520: assessed_comps number default 0;
521: l_comp_log varchar2(32767);
522:
523: l_out_from_date per_comp_element_outcomes.DATE_FROM%type;
524: l_out_ovn per_comp_element_outcomes.OBJECT_VERSION_NUMBER%type;
525: l_comp_ele_out_id per_comp_element_outcomes.COMP_ELEMENT_OUTCOME_ID%type;
526: l_comp_status per_competence_elements.status%type;
527: l_achieved_date per_competence_elements.ACHIEVED_DATE%type;
528:

Line 525: l_comp_ele_out_id per_comp_element_outcomes.COMP_ELEMENT_OUTCOME_ID%type;

521: l_comp_log varchar2(32767);
522:
523: l_out_from_date per_comp_element_outcomes.DATE_FROM%type;
524: l_out_ovn per_comp_element_outcomes.OBJECT_VERSION_NUMBER%type;
525: l_comp_ele_out_id per_comp_element_outcomes.COMP_ELEMENT_OUTCOME_ID%type;
526: l_comp_status per_competence_elements.status%type;
527: l_achieved_date per_competence_elements.ACHIEVED_DATE%type;
528:
529: BEGIN