APPS.PER_ONEBOX_VACBAL_ACCRUAL SQL Statements

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

Line: 4

    select distinct paf.assignment_id,
           pap.accrual_plan_id
    from pay_accrual_plans pap,
         per_assignments_f paf,
         per_people_f ppf,
         pay_element_types_f pet,
         pay_element_entries_f pee,
         pay_element_links_f pel
where pap.accrual_plan_element_type_id = pet.element_type_id
and pel.element_link_id = pee.element_link_id
and pel.element_type_id = pet.element_type_id
and pee.assignment_id = paf.assignment_id
and paf.person_id = ppf.person_id
and ppf.person_id = p_person_id
and pap.accrual_category = 'V'
and sysdate between paf.effective_start_date and paf.effective_end_date
and sysdate between ppf.effective_start_date and ppf.effective_end_date
and sysdate between pee.effective_start_date and pee.effective_end_date
and sysdate between pel.effective_start_date and pel.effective_end_date
and sysdate between pet.effective_start_date and pet.effective_end_date;