APPS.PQP_VEHICLE_MILEAGE SQL Statements

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

Line: 13

SELECT element_name
      ,substr(pete.EEI_INFORMATION1,0,1) ownership
from pay_element_types_f pet,
     pay_element_type_extra_info pete
where exists (SELECT 'X'
                from pay_run_results  prr
                     ,pay_assignment_actions paa
                     ,pay_payroll_actions ppa
               WHERE prr.element_type_id=pet.element_type_id
                 AND prr.assignment_action_id=paa.assignment_action_id
                 AND paa.payroll_action_id=ppa.payroll_action_id
                AND ppa.effective_date BETWEEN TO_DATE('04/06/2003','MM/DD/YYYY')
                                           AND TO_DATE('04/05/2004','MM/DD/YYYY')
                                            )
 AND pete.element_type_id=pet.element_type_id
 AND pete.information_type='PQP_VEHICLE_MILEAGE_INFO'
 AND pete.EEI_INFORMATION_CATEGORY='PQP_VEHICLE_MILEAGE_INFO'
 AND pete.EEI_INFORMATION1 in ('C','P','PM','PP','CM','CP')
 AND pet.business_group_id =cp_business_group_id;

Line: 39

SELECT element_name
 FROM pay_element_types_f pet
WHERE NOT EXISTS (SELECT 'X'
                    FROM pay_element_links_f pel
                   WHERE pel.element_type_id=pet.element_type_id
                     AND pel.business_group_id=pet.business_group_id
                       )
  AND ( pet.element_name like cp_element_name||'%Addl Ele%'
  OR (pet.element_name like cp_element_name||'%Mileage Res2%'
  AND cp_ownership = 'C'))
  AND pet.business_group_id=cp_business_group_id ;

Line: 54

select purt.location_name||' Needs to be linked to Assignment '
       ||paaf.assignment_number||' of Employee '||papf.full_name ERROR_LOG
       from pay_us_rpt_totals purt
           ,per_all_assignments_f paaf
           ,per_all_people_f papf
       where purt.state_name = 'CARMILEAGE_UPGRADE'
       and purt.tax_unit_id = 250
       and paaf.assignment_id = purt.location_id
       and fnd_date.canonical_to_date(purt.organization_name) between paaf.effective_start_date
       and paaf.effective_end_date
       and paaf.person_id = papf.person_id
       and fnd_date.canonical_to_date(purt.organization_name) between papf.effective_start_date
       and papf.effective_end_date;