APPS.PAY_HK_RULES SQL Statements

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

Line: 24

   select fnd_number.canonical_to_number(target.ENTRY_INFORMATION1)
   from pay_element_entries_f target
       ,pay_assignment_actions paa
       ,pay_payroll_actions ppa
   where ppa.payroll_action_id = paa.payroll_action_id
   and   target.element_entry_id = p_ee_id
   and   target.assignment_id = paa.assignment_id
   and   ppa.effective_date between target.effective_start_date
                                and target.effective_end_date
   and   paa.assignment_action_id = p_asg_act_id;