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