APPS.WIP_WS_SKILL_CHECK_PVT dependencies on PER_COMPETENCES

Line 139: FROM per_competences

135: G_PREF_CERTIFY_VALUE = G_ENABLE_CERTIFICATION_CHECK then
136:
137: select nvl(certification_required,'N')
138: into l_comp_certify_required
139: FROM per_competences
140: WHERE competence_id = v_job_op_competence(l_counter).competency_id;
141:
142: if l_comp_certify_required='Y' and
143: (l_certify_date is null or