DBA Data[Home] [Help]

APPS.HR_COMPLETE_APPRAISAL_SS dependencies on PER_COMPETENCE_OUTCOMES

Line 505: per_competence_outcomes co

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
509: AND nvl(co.date_to,nvl(ceo.date_to,trunc(sysdate))) >= nvl(ceo.date_to,trunc(sysdate));