DBA Data[Home] [Help]

APPS.PQP_GB_PENSION_FUNCTIONS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 87: FROM pay_element_type_extra_info

83: WHERE pet.element_type_id = c_element_type_id
84: AND c_effective_date BETWEEN pet.effective_start_date
85: AND pet.effective_end_date
86: AND EXISTS ( SELECT 1
87: FROM pay_element_type_extra_info
88: WHERE element_type_id = pet.element_type_id
89: AND information_type = 'PQP_GB_PENSION_SCHEME_INFO'
90: AND eei_information4 = c_pension_category
91: AND eei_information12 IS NULL);

Line 179: FROM pqp_gb_pension_schemes_v pps, pay_element_type_extra_info eeit

175: ,c_business_group_id NUMBER
176: )
177: IS
178: SELECT pps.element_type_id
179: FROM pqp_gb_pension_schemes_v pps, pay_element_type_extra_info eeit
180: WHERE pps.element_type_id <> c_element_type_id
181: AND pps.pension_scheme_name = eeit.eei_information1
182: AND eeit.element_type_id = c_element_type_id
183: AND eeit.information_type = 'PQP_GB_PENSION_SCHEME_INFO'