APPS.PAY_PAYWSLEE_PKG SQL Statements

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

Line: 25

	select	input_value_tl.name
	--
	from	pay_input_values_f_tl INPUT_VALUE_TL,
                pay_input_values_f INPUT_VALUE
	--
	where	input_value.element_type_id	= p_element_type_id
        and     input_value_tl.input_value_id  = input_value.input_value_id
        and     userenv('LANG') = input_value_tl.language
	and	input_value.effective_start_date =
		(select min (element.effective_start_date)
		from	pay_element_types_f	ELEMENT
		where	element.element_type_id = p_element_type_id)
		--
	order by	input_value.display_sequence,
			input_value_tl.name;

Line: 147

        select  input_value_tl.name
        --
        from    pay_input_values_f_tl INPUT_VALUE_TL,
                pay_input_values_f INPUT_VALUE
        --
        where   input_value.element_type_id     = p_element_type_id
        and     input_value_tl.input_value_id  = input_value.input_value_id
        and     userenv('LANG') = input_value_tl.language
        and     input_value.effective_start_date =
                (select min (element.effective_start_date)
                from    pay_element_types_f     ELEMENT
                where   element.element_type_id = p_element_type_id)
        order by        input_value.display_sequence,
                        input_value_tl.name;

Line: 217

	select	person.full_name,
		asgt.assignment_number
	from	per_people_f		PERSON,
		per_assignments_f2	ASGT
	where	person.person_id 	= asgt.person_id
	and	asgt.assignment_id	= p_assignment_id
	and	p_effective_end_date between asgt.effective_start_date
					and asgt.effective_end_date
	and	p_effective_end_date between person.effective_start_date
					and person.effective_end_date;

Line: 230

	select	entry.screen_entry_value,
		type.uom,
		type.hot_default_flag,
		type.lookup_type,
		type.value_set_id,
		nvl (link.default_value, type.default_value) HOT_DEFAULT_VALUE
	from	pay_element_entry_values_f	ENTRY,
		pay_link_input_values_f		LINK,
		pay_input_values_f		TYPE
	where	entry.element_entry_id = p_element_entry_id
	and	link.element_link_id = p_element_link_id
	and	link.input_value_id = entry.input_value_id
	and	type.input_value_id = entry.input_value_id
	and	p_effective_end_date = entry.effective_end_date
	and	p_effective_end_date between link.effective_start_date
					and link.effective_end_date
	and	p_effective_end_date between type.effective_start_date
					and type.effective_end_date
	order by type.display_sequence, type.name;

Line: 752

        select  person.full_name,
                asgt.assignment_number
        from    per_people_f            PERSON,
                per_assignments_f2      ASGT
        where   person.person_id        = asgt.person_id
        and     asgt.assignment_id      = p_assignment_id
        and     p_effective_end_date between asgt.effective_start_date
                                        and asgt.effective_end_date
        and     p_effective_end_date between person.effective_start_date
                                        and person.effective_end_date;

Line: 765

        select  entry.screen_entry_value,
                type.uom,
                type.hot_default_flag,
                type.lookup_type,
		type.value_set_id,
                nvl (link.default_value, type.default_value) HOT_DEFAULT_VALUE
        from    pay_element_entry_values_f      ENTRY,
                pay_link_input_values_f         LINK,
                pay_input_values_f              TYPE
        where   entry.element_entry_id = p_element_entry_id
        and     link.element_link_id = p_element_link_id
        and     link.input_value_id = entry.input_value_id
        and     type.input_value_id = entry.input_value_id
        and     p_effective_end_date = entry.effective_end_date
        and     p_effective_end_date between link.effective_start_date
                                        and link.effective_end_date
        and     p_effective_end_date between type.effective_start_date
                                        and type.effective_end_date
        order by type.display_sequence, type.name;