eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_COMPLETE_APPRAISAL_SS dependencies on PER_COMP_ELEMENT_OUTCOMES

Line 692: FROM per_comp_element_outcomes ceo, per_competence_outcomes co

688: ceo.information17,
689: ceo.information18,
690: ceo.information19,
691: ceo.information20
692: FROM per_comp_element_outcomes ceo, per_competence_outcomes co
693: WHERE ceo.competence_element_id = p_competence_element_id
694: AND co.outcome_id = ceo.outcome_id
695: AND co.date_from <= ceo.date_from
696: AND NVL (co.date_to, NVL (ceo.date_to, TRUNC (SYSDATE))) >=

Line 710: l_out_from_date per_comp_element_outcomes.date_from%TYPE;

706: each_comp_status VARCHAR2 (10);
707: error_message VARCHAR2 (500) DEFAULT NULL;
708: assessed_comps NUMBER DEFAULT 0;
709: l_comp_log VARCHAR2 (32767);
710: l_out_from_date per_comp_element_outcomes.date_from%TYPE;
711: l_out_ovn per_comp_element_outcomes.object_version_number%TYPE;
712: l_comp_ele_out_id per_comp_element_outcomes.comp_element_outcome_id%TYPE;
713: l_comp_status per_competence_elements.status%TYPE;
714: l_achieved_date per_competence_elements.achieved_date%TYPE;

Line 711: l_out_ovn per_comp_element_outcomes.object_version_number%TYPE;

707: error_message VARCHAR2 (500) DEFAULT NULL;
708: assessed_comps NUMBER DEFAULT 0;
709: l_comp_log VARCHAR2 (32767);
710: l_out_from_date per_comp_element_outcomes.date_from%TYPE;
711: l_out_ovn per_comp_element_outcomes.object_version_number%TYPE;
712: l_comp_ele_out_id per_comp_element_outcomes.comp_element_outcome_id%TYPE;
713: l_comp_status per_competence_elements.status%TYPE;
714: l_achieved_date per_competence_elements.achieved_date%TYPE;
715: BEGIN

Line 712: l_comp_ele_out_id per_comp_element_outcomes.comp_element_outcome_id%TYPE;

708: assessed_comps NUMBER DEFAULT 0;
709: l_comp_log VARCHAR2 (32767);
710: l_out_from_date per_comp_element_outcomes.date_from%TYPE;
711: l_out_ovn per_comp_element_outcomes.object_version_number%TYPE;
712: l_comp_ele_out_id per_comp_element_outcomes.comp_element_outcome_id%TYPE;
713: l_comp_status per_competence_elements.status%TYPE;
714: l_achieved_date per_competence_elements.achieved_date%TYPE;
715: BEGIN
716: -- write an utility to get the value to apply the changes or not