APPS.PAY_PAYWIEEH_PKG SQL Statements

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

Line: 89

	select	type_tl.name,
		type.uom,
		decode (type.lookup_type,
			null, decode (type.hot_default_flag,
					'N', entry.screen_entry_value,
					'Y', nvl (entry.screen_entry_value, nvl (link.default_value, type.default_value))),
			hr_general.decode_lookup (type.lookup_type,
						decode (type.hot_default_flag,
							'N', entry.screen_entry_value,
							'Y', nvl (entry.screen_entry_value,
								nvl (link.default_value,
									type.default_value))))) SCREEN_ENTRY_VALUE
	from    pay_input_values_f_tl           TYPE_TL,
                pay_input_values_f              TYPE,
		pay_element_entry_values_f	ENTRY,
		pay_link_input_values_f		LINK
	where   link.element_link_id  = p_element_link_id
        and	entry.element_entry_id = p_element_entry_id
	and	link.input_value_id = entry.input_value_id + 0
	and	type.input_value_id = entry.input_value_id
	and	type_tl.input_value_id = type.input_value_id
        and     userenv('LANG') = type_tl.language
	and	p_effective_date = entry.effective_start_date
	and	entry.effective_start_date between link.effective_start_date
					and link.effective_end_date
	and	entry.effective_start_date between type.effective_start_date
					and type.effective_end_date
	order by type.display_sequence, type_tl.name;

Line: 237

	select	cost_allocation_structure
	from	per_business_groups_perf
	where	business_group_id + 0 = p_business_group_id;