APPS.PER_IE_VEHICLE_ALLOC_RULES SQL Statements

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

Line: 4

PROCEDURE element_end_date_update (
  p_vehicle_allocation_id   IN  NUMBER,
  p_effective_date          IN  DATE) IS

l_proc VARCHAR2(30) := 'PER_IE_VEHICLE_ALLOC_RULES';

Line: 11

SELECT pee.element_entry_id,
       max(pee.object_version_number),
       max(ppa.effective_date),
       max(ppa.date_earned)                              -- 5872123
FROM   pay_element_types_f pet,
       pay_element_entry_values_f peev,
       pay_input_values_f piv,
       pay_element_entries_f pee,
       pqp_vehicle_allocations_f pva,
       pay_element_links_f  pel,
       pay_payroll_actions ppa,
       pay_assignment_actions paas,
       pay_run_results prr,
       per_all_assignments_f paa
WHERE  pee.assignment_id = pva.assignment_id
AND    p_effective_date BETWEEN
       pee.effective_start_date AND pee.effective_end_date
AND    pel.element_type_id = pet.element_type_id    -- Bug No.3648575
AND    pel.element_link_id = pee.element_link_id    -- Bug No.3648575
AND    pee.element_type_id + 0 = pet.element_type_id -- Bug No.3648575
AND    pet.element_name = 'IE BIK Company Vehicle'
AND    p_effective_date BETWEEN
       pet.effective_start_date AND pet.effective_end_date -- Bug No.3648575
AND    peev.element_entry_id = pee.element_entry_id
AND    p_effective_date BETWEEN
       peev.effective_start_date AND peev.effective_end_date
AND    peev.screen_entry_value =to_char(p_vehicle_allocation_id)
AND    peev.input_value_id = piv.input_value_id
AND    piv.name = 'Vehicle Allocation'
AND    p_effective_date BETWEEN
        piv.effective_start_date AND piv.effective_end_date
AND    pva.vehicle_allocation_id = p_vehicle_allocation_id
AND    p_effective_date BETWEEN
        pva.effective_start_date AND pva.effective_end_date
AND    p_effective_date BETWEEN
        pel.effective_start_date AND pel.effective_end_date
AND    prr.element_entry_id=pee.element_entry_id
AND    prr.element_type_id=pet.element_type_id
AND    prr.assignment_action_id=paas.assignment_action_id
AND    paas.payroll_action_id=ppa.payroll_action_id
AND    paas.assignment_id=paa.assignment_id
AND    paa.payroll_id=ppa.payroll_id
AND    ppa.action_type in ('R','Q')
AND    ppa.action_status='C'
AND    paa.assignment_id=pva.assignment_id
AND    ppa.effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
AND    ppa.effective_date BETWEEN paa.effective_start_date AND paa.effective_end_date
AND    ppa.effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
AND    ppa.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
AND    ppa.effective_date BETWEEN piv.effective_start_date AND piv.effective_end_date
AND    ppa.effective_date BETWEEN pel.effective_start_date AND pel.effective_end_date
group by pee.element_entry_id;

Line: 65

SELECT min(ptp.end_date)
FROM   per_time_periods ptp,
       per_all_assignments_f paa,
       pqp_vehicle_allocations_f pva
WHERE  ptp.payroll_id = paa.payroll_id
AND    paa.assignment_id = pva.assignment_id
AND    pva.vehicle_allocation_id = p_vehicle_allocation_id
-- AND    ptp.regular_payment_date>p_max_effective_date;                                  -- 5872123

Line: 82

l_delete_warning        BOOLEAN;

Line: 117

	hr_utility.set_location('Calling delete_element_entry',25);

Line: 119

	pay_element_entry_api.delete_element_entry (
	      p_validate              => FALSE,
	      p_datetrack_delete_mode => 'DELETE',
	      p_effective_date        => l_period_end_date,
	      p_element_entry_id      => l_element_entry_id,
	      p_object_version_number => l_object_version_number,
	      p_effective_start_date  => l_effective_start_date,
	      p_effective_end_date    => l_effective_end_date,
	      p_delete_warning        => l_delete_warning
	    );

Line: 141

END element_end_date_update;