DBA Data[Home] [Help]

APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on HR_LOOKUPS

Line 362: ,hr_lookups hrl

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)
365: AND eei.eei_information1 = hrl.lookup_code
366: AND eei.information_type = 'PQP_UK_RATE_TYPE'