APPS.PAY_PAYWSMEE2_PKG SQL Statements

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

Line: 85

select *
from   pay_element_entries_f
where  element_entry_id = p_element_entry_id
and p_effective_date between effective_start_date and effective_end_date
for update of element_entry_id      nowait;

Line: 480

	select	coverage.meaning,
		benefit.employee_contribution,
		benefit.employer_contribution
		--
	from	ben_benefit_contributions_f	BENEFIT,
		hr_lookups			COVERAGE
		--
	where	coverage.lookup_type = 'US_BENEFIT_COVERAGE'
	and	coverage.lookup_code = benefit.coverage_type
	and	benefit.element_type_id = p_element_type_id
	and	p_effective_date between benefit.effective_start_date
					and benefit.effective_end_date
	and	1 = (select count (*)
			from ben_benefit_contributions_f BENEFIT2
			where benefit2.element_type_id = p_element_type_id
			and p_effective_date between benefit2.effective_start_date
						and benefit2.effective_end_date)
					;

Line: 501

	select	type.input_value_id,
		type_tl.name,
		type.uom,
		type.lookup_type,
      type.value_set_id,
		type.formula_id,
		decode (type.hot_default_flag,
			'N',link.warning_or_error,
			nvl (link.warning_or_error,
				type.warning_or_error)) WARNING_OR_ERROR,
		type.mandatory_flag,
		decode (p_contributions_used,
			'Y',decode (type.name,
					g_er_contributions, 'Y',
					g_ee_contributions, 'Y',
					type.hot_default_flag),
			type.hot_default_flag) HOT_DEFAULT_FLAG,
		decode(type.hot_default_flag,'N',link.min_value,
                       nvl(link.min_value,type.min_value)) MIN_VALUE,
		decode(type.hot_default_flag,'N',link.max_value,
                       nvl(link.max_value,type.max_value)) MAX_VALUE,
                pay_paywsmee_pkg.formatted_default (	link.default_value,
							type.default_value,
							type.uom,
							type.hot_default_flag,
							p_contributions_used,
							type.name,
							p_input_currency_code,
							type.lookup_type,
                     type.value_set_id) DEFAULT_VALUE
		--
	from	pay_input_values_f	TYPE,
                pay_input_values_f_tl   TYPE_TL,
		pay_link_input_values_f	LINK
		--
	where	type_tl.input_value_id = type.input_value_id
        and     userenv('LANG') = type_tl.language
        and     p_effective_date between type.effective_start_date
					and type.effective_end_date
	and	p_effective_date between link.effective_start_date
					and link.effective_end_date
	and	p_element_link_id	= link.element_link_id
	and	type.input_value_id	= link.input_value_id
	order by type.display_sequence, type.name;