APPS.PAY_FI_TAX_CARD_PKG SQL Statements

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

Line: 49

p_sqlstr := 'SELECT DISTINCT person_id
      FROM  per_people_f ppf
           ,pay_payroll_actions ppa
      WHERE ppa.payroll_action_id = :payroll_action_id
      AND   ppa.business_group_id = ppf.business_group_id
      ORDER BY ppf.person_id';

Line: 64

select peev.SCREEN_ENTRY_VALUE
from
pay_element_types_f pet
,pay_element_entries_f  pee
,pay_input_values_f piv
,pay_element_entry_values_f peev
where pee.element_type_id = pet.element_type_id
and pet.element_name = 'Tax'
and pet.legislation_code='FI'
and l_effective_date between pet.effective_start_date and pet.effective_end_date
and l_effective_date between pee.effective_start_date and pee.effective_end_date
and pet.element_type_id = piv.element_type_id
and l_effective_date between piv.effective_start_date and piv.effective_end_date
and piv.name = 'Primary Employment'
and piv.input_value_id = peev.input_value_id
and peev.element_entry_id = pee.element_entry_id
and l_effective_date between peev.effective_start_date and peev.effective_end_date
and assignment_id =  l_assignment_id;