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  b.screen_entry_value
      , TYPE.uom
      , TYPE.hot_default_flag
      , TYPE.lookup_type
      , TYPE.value_set_id
      , nvl (b.default_value, TYPE.default_value) hot_default_value
FROM    (
        SELECT  *
        FROM    pay_input_values_f piv
              , pay_element_links_f pil
        WHERE   pil.element_type_id = piv.element_type_id
        AND     pil.element_link_id = p_element_link_id
        and     piv.effective_start_date =
                (select min (element.effective_start_date)
                from    pay_element_types_f     ELEMENT
                where   element.element_type_id = piv.element_type_id)
        ) TYPE
      ,
        (
        SELECT  entry.*
              , link.default_value
        FROM    pay_element_entry_values_f entry
              , pay_link_input_values_f link
        WHERE   element_entry_id = p_element_entry_id
        AND     link.input_value_id = entry.input_value_id
        AND     link.element_link_id = p_element_link_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
        ) b
WHERE   TYPE.input_value_id = b.input_value_id (+)
ORDER BY type.display_sequence
       , type.name  ;

Line: 766

        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: 779

        SELECT  b.screen_entry_value
      , TYPE.uom
      , TYPE.hot_default_flag
      , TYPE.lookup_type
      , TYPE.value_set_id
      , nvl (b.default_value, TYPE.default_value) hot_default_value
FROM    (
        SELECT  *
        FROM    pay_input_values_f piv
              , pay_element_links_f pil
        WHERE   pil.element_type_id = piv.element_type_id
        AND     pil.element_link_id = p_element_link_id
        and     piv.effective_start_date =
                (select min (element.effective_start_date)
                from    pay_element_types_f     ELEMENT
                where   element.element_type_id = piv.element_type_id)
        ) TYPE
      ,
        (
        SELECT  entry.*
              , link.default_value
        FROM    pay_element_entry_values_f entry
              , pay_link_input_values_f link
        WHERE   element_entry_id = p_element_entry_id
        AND     link.input_value_id = entry.input_value_id
        AND     link.element_link_id = p_element_link_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
        ) b
WHERE   TYPE.input_value_id = b.input_value_id (+)
ORDER BY type.display_sequence
       , type.name  ;