DBA Data[Home] [Help]

APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_ELEMENT_TYPES_F_TL

Line 257: FROM pay_element_types_f pet, pay_element_types_f_tl petl

253: -- Cursor to get element name
254: CURSOR csr_get_element_name
255: IS
256: SELECT petl.element_name
257: FROM pay_element_types_f pet, pay_element_types_f_tl petl
258: WHERE petl.element_type_id = pet.element_type_id
259: AND petl.LANGUAGE = USERENV('LANG')
260: AND pet.element_type_id = p_element_type_id
261: AND p_effective_date BETWEEN pet.effective_start_date