DBA Data[Home] [Help]

APPS.WIP_WS_SKILL_CHECK_PVT dependencies on PER_COMPETENCE_ELEMENTS

Line 123: FROM per_competence_elements

119: if v_job_op_competence(l_counter).competency_id is not null then
120: begin
121: SELECT certification_date, next_certification_date
122: into l_certify_date,l_next_review_date
123: FROM per_competence_elements
124: WHERE type = 'PERSONAL'
125: AND person_id = p_emp_id
126: AND trunc(sysdate) between effective_date_from and NVL(effective_date_to,trunc(sysdate))
127: and competence_id = v_job_op_competence(l_counter).competency_id