DBA Data[Home] [Help]

APPS.WIP_WS_SKILL_CHECK_PVT dependencies on DUAL

Line 155: from dual

151: v_job_op_competence(l_counter).qualification_type_id is not null then
152: begin
153: select 1
154: into l_validate_skill
155: from dual
156: where exists (select 'x'
157: from per_qualifications
158: where person_id = p_emp_id
159: and qualification_type_id = v_job_op_competence(l_counter).qualification_type_id);

Line 200: from dual

196: if G_PREF_CLOCK_VALUE in (G_ALLOW_ONLY_SKILL_OPERATORS,G_ALLOW_ALL_OPERATORS) AND
197: l_validate_skill= G_SKILL_VALIDATION_SUCCESS then
198: begin
199: select 1 into l_op_competence_exist
200: from dual
201: where exists (select 1
202: from wip_operation_competencies
203: where wip_entity_id = p_wip_entity_id
204: and operation_seq_num = p_operation );