DBA Data[Home] [Help]

APPS.HR_COMPLETE_APPRAISAL_SS dependencies on PER_COMPETENCE_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))) >=