APPS.HR_APPROVAL_WF SQL Statements

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

Line: 12

  select  ppf.person_id
    from    per_assignments_f paf
           ,per_people_f      ppf
    where   paf.person_id             = l_in_person_id
    and     paf.primary_flag          = 'Y'
    and     (paf.assignment_type = 'E' and ppf.current_employee_flag = 'Y'
          or paf.assignment_type = 'C' and ppf.current_npw_flag = 'Y')
    and     sysdate
    between paf.effective_start_date
    and     paf.effective_end_date
    and     ppf.person_id             = paf.supervisor_id
    and     sysdate
    between ppf.effective_start_date
    and     ppf.effective_end_date;

Line: 30

    SELECT  email_address
    FROM    per_people_f pp
    WHERE   pp.person_id = p_person_id
    AND     l_effective_date
    between pp.effective_start_date
    and     pp.effective_end_date;

Line: 39

    SELECT recruiter_id,job_id
    FROM   per_vacancies pv
    WHERE  pv.vacancy_id = p_vacancy_id;

Line: 160

    select 1
    from   wf_item_attribute_values wiav
    where  wiav.item_type = p_item_type
    and    wiav.item_key  = p_item_key
    and    wiav.name      = p_name;