APPS.PAY_PAYJPGMT_XMLP_PKG SQL Statements

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

Line: 295

SELECT pee.element_entry_id ee_id,
  pee.effective_start_date ee_esd,
  pee.effective_end_date ee_eed,
  peev1.screen_entry_value applied_mth,
  peev2.screen_entry_value new_std_mth_comp
FROM pay_element_entry_values_f peev2,
  pay_element_entry_values_f peev1,
  pay_link_input_values_f pliv2,
  pay_link_input_values_f pliv1,
  pay_element_entries_f pee
WHERE pee.assignment_id = p_assignment_id

 AND pee.effective_start_date < p_effective_date
 AND pliv1.element_link_id = pee.element_link_id
 AND pliv2.element_link_id = pee.element_link_id
 AND pliv1.input_value_id = p_applied_mth_iv_id
 AND pliv2.input_value_id = p_new_std_mth_comp_iv_id
 AND pee.effective_start_date BETWEEN pliv1.effective_start_date
 AND pliv1.effective_end_date
 AND pee.effective_start_date BETWEEN pliv2.effective_start_date
 AND pliv2.effective_end_date
 AND peev1.element_entry_id = pee.element_entry_id
 AND peev1.input_value_id = pliv1.input_value_id
 AND peev1.effective_start_date = pee.effective_start_date
 AND peev1.effective_end_date = pee.effective_end_date
 AND peev2.element_entry_id = pee.element_entry_id
 AND peev2.input_value_id = pliv2.input_value_id
 AND peev2.effective_start_date = pee.effective_start_date
 AND peev2.effective_end_date = pee.effective_end_date
ORDER BY pee.effective_start_date;