APPS.HR_WPM_UTIL SQL Statements

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

Line: 9

    select distinct 'Y' as if_current
    from   per_appraisal_periods
    where  plan_id = c_plan_id
           and trunc(sysdate) between nvl(task_start_date,sysdate) and nvl(task_end_date,sysdate);

Line: 55

    select distinct 'Y' as enabled
    from   per_objectives
    where  aligned_with_objective_id = c_obj_id;

Line: 80

    select distinct 'Y' as enabled
    from   per_objectives
    where  objective_id = c_align_id;