APPS.PAY_US_DEDN_PKG SQL Statements

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

Line: 23

      select  sum(nvl(peev.screen_entry_value,0))
      into l_Total_owed
      from
	   pay_element_entry_values_f peev,
           pay_input_values_f piv,
           pay_element_links_f pel,
           pay_element_entries_f pee
      where pee.assignment_id = p_assignment_id
      and  p_date_earned between  pee.effective_start_date
                          and     pee.effective_end_date
      and  pee.element_link_id = pel.element_link_id
      and  p_date_earned between  pel.effective_start_date
                          and     pel.effective_end_date
      and  pel.element_type_id = p_element_type_id
      and  piv.element_type_id = p_element_type_id
      and  piv.name = 'Total Owed'
      and  p_date_earned between  piv.effective_start_date
                          and     piv.effective_end_date
      and  piv.input_value_id = peev.input_value_id
      and  pee.element_entry_id = peev.element_entry_id
      and  p_date_earned between  peev.effective_start_date
                          and     peev.effective_end_date;