APPS.PAY_GB_WORKING_TAX_CREDIT SQL Statements

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

Line: 73

	select piv.input_value_id
	from pay_input_values_f piv,
	     pay_element_types_f petf
	where petf.element_type_id = piv.element_type_id
	and petf.element_name = 'Working Tax Credit'
	and piv.name = 'Daily Amount'
	and petf.legislation_code = 'GB';

Line: 86

	select peef.effective_start_date as start_date,
	       peef.effective_end_date	 as end_date,
		max(decode(peev.input_value_id,l_daily_amt_iv_id,
			fnd_number.canonical_to_number(peev.Screen_entry_value),null)) as daily_amount
	from pay_element_entry_values_f peev,
	     pay_element_entries_f peef,
	     pay_element_links_f pelf,
	     pay_element_types_f petf
	where pelf.element_link_id = peef.element_link_id
	and peef.element_entry_id = peev.element_entry_id
	and petf.element_type_id = pelf.element_type_id
	and peev.effective_start_date = peef.effective_start_date
	and upper(petf.element_name) = upper('Working Tax Credit')
	and petf.legislation_code = 'GB'
	and peef.assignment_id = p_assignment_id
	and peef.effective_start_date <= p_end_date
	and (	peef.effective_start_date >= p_start_date
	 	OR (peef.effective_start_date <= p_start_date
	     	    AND peef.effective_end_date >= p_start_date)
	    )
	and peef.entry_type = 'E'
	group by peef.effective_start_date, peef.effective_end_date;