DBA Data[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 800: from pay_element_type_extra_info eei1

796: ,c_business_group_id NUMBER DEFAULT NULL
797: ) is
798: select eei2.element_type_extra_info_id
799: ,eei1.element_type_id
800: from pay_element_type_extra_info eei1
801: ,pay_element_type_extra_info eei2
802: ,hr_lookups hrl
803: ,pay_element_types_f petf
804: where hrl.lookup_type = 'PQP_RATE_TYPE'

Line 801: ,pay_element_type_extra_info eei2

797: ) is
798: select eei2.element_type_extra_info_id
799: ,eei1.element_type_id
800: from pay_element_type_extra_info eei1
801: ,pay_element_type_extra_info eei2
802: ,hr_lookups hrl
803: ,pay_element_types_f petf
804: where hrl.lookup_type = 'PQP_RATE_TYPE'
805: and hrl.meaning = c_name