APPS.PAY_IE_BIK_CHECK SQL Statements

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

Line: 19

     SELECT count(*)
      FROM pay_element_types_f pet
          ,pay_element_links_f pel
          ,pay_element_entries_f pee
   WHERE pel.element_type_id =pet.element_type_id
     AND pee.assignment_id   = p_assignment_id
     AND pel.element_link_id = pee.element_link_id
     AND pet.legislation_code = 'IE'
     AND pet.element_name =('IE BIK Company Vehicle');*/

Line: 31

     SELECT count(*)
     FROM pay_element_types_f pet
	,pay_element_links_f pel
	,pay_element_entries_f pee
	,pay_input_values_f piv
	,pay_element_entry_values_f peev
     WHERE pel.element_type_id =pet.element_type_id
     AND pee.assignment_id   = p_assignment_id
     AND pel.element_link_id = pee.element_link_id
     AND pet.legislation_code = 'IE'
     AND piv.element_type_id = pet.element_type_id
     AND peev.element_entry_id = pee.element_entry_id
     AND peev.input_value_id = piv.input_value_id
     AND pet.element_name =('IE BIK Company Vehicle')
     AND piv.name = 'Vehicle Allocation'
     AND peev.screen_entry_value = p_vehicle_allocation_id;

Line: 75

SELECT count(*)
      FROM pay_element_types_f pet
          ,pay_element_links_f pel
          ,pay_element_entries_f pee
   WHERE pel.element_type_id =pet.element_type_id
     AND pee.assignment_id   = p_assignment_id
     AND pel.element_link_id = pee.element_link_id
     AND pet.legislation_code = 'IE'
     AND pet.element_name =('IE BIK Company Vehicle')
     AND p_effective_date < pee.effective_end_date;

Line: 129

      hr_utility.set_location('Purge delete status:'||l_return_status,2);

Line: 135

 /* ELSIF p_datetrack_mode = 'DELETE' THEN
       --This is for enddate
       l_return_status := enddate_veh_alloc
                              ( p_assignment_id   => p_assignment_id_o
                               ,p_effective_date  =>p_effective_date);

Line: 140

       hr_utility.set_location('End date delete status :'||l_return_status,3);