APPS.WIP_WS_SKILL_CHECK_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

        select attribute_name,
        attribute_value_code
        from wip_preference_values
        where preference_id = 41
        and level_id = 1
        and attribute_name <> G_PREF_ORG_ATTRIBUTE
        and sequence_number = (select sequence_number
                               from wip_preference_values
                               where preference_id = 41
                               and level_id = 1
                               and attribute_name = G_PREF_ORG_ATTRIBUTE
                               and attribute_value_code = to_char(p_organization_id))
        order by 1 desc;

Line: 40

        select wip_entity_name
        into G_WIP_ENTITY_NAME
        from wip_entities
        where wip_entity_id =  p_wip_entity_id;

Line: 45

        select full_name
        into G_EMPLOYEE
        from per_all_people_f
        where person_id = p_emp_id
        and sysdate between effective_start_date and nvl(effective_end_date,sysdate+1);

Line: 61

        select nvl(check_skill,2)
        into l_check_skill
        from wip_operations
        where wip_entity_id = p_wip_entity_id
        and operation_seq_num = p_op_seq_num;

Line: 86

        select competence_id,rating_level_id,qualification_type_id
        from wip_operation_competencies
        where wip_entity_id = p_wip_entity_id
        and operation_seq_num = p_operation;

Line: 121

                    SELECT certification_date,  next_certification_date
                    into l_certify_date,l_next_review_date
                    FROM  per_competence_elements
                    WHERE type = 'PERSONAL'
                    AND person_id = p_emp_id
                    AND trunc(sysdate) between effective_date_from and NVL(effective_date_to,trunc(sysdate))
                    and competence_id = v_job_op_competence(l_counter).competency_id
                    and nvl(proficiency_level_id,-1) = nvl(v_job_op_competence(l_counter).rating_level_id ,nvl(proficiency_level_id,-1));

Line: 137

                    select nvl(certification_required,'N')
                    into l_comp_certify_required
                    FROM per_competences
                    WHERE competence_id = v_job_op_competence(l_counter).competency_id;

Line: 153

                    select 1
                    into l_validate_skill
                    from   dual
                    where exists (select 'x'
                                  from per_qualifications
                                  where person_id = p_emp_id
                                  and qualification_type_id = v_job_op_competence(l_counter).qualification_type_id);

Line: 183

        select distinct employee_id
        from wip_resource_actual_times
        where organization_id = p_organization_id
        and wip_entity_id = p_wip_entity_id
        and operation_seq_num = p_operation;

Line: 199

                select 1 into l_op_competence_exist
                from dual
                where exists (select 1
                             from wip_operation_competencies
                             where wip_entity_id = p_wip_entity_id
                             and operation_seq_num = p_operation );

Line: 246

        select organization_id
        into l_org_id
        from wip_entities
        where wip_entity_id = p_wip_entity_id
        and rownum=1;

Line: 326

            l_sql := ' select operation_seq_num,nvl(check_skill,2) '||
                     ' from wip_operations '||
                     ' where organization_id = :1 '||
                     ' and wip_entity_id = :2 '||
                     l_add_where_clause;