DBA Data[Home] [Help]

APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 360: FROM pay_element_type_extra_info eei

356: ,c_rate_type VARCHAR2
357: )
358: IS
359: SELECT pet.element_type_id
360: FROM pay_element_type_extra_info eei
361: ,pay_element_types_f pet
362: ,hr_lookups hrl
363: WHERE hrl.lookup_type = 'PQP_RATE_TYPE'
364: AND UPPER(hrl.meaning) = UPPER(c_rate_type)