DBA Data[Home] [Help]

APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_ELEMENT_TYPES_F_TL

Line 337: FROM pay_element_types_f pet, pay_element_types_f_tl petl

333: -- Cursor to get element name
334: CURSOR csr_get_element_name
335: IS
336: SELECT petl.element_name
337: FROM pay_element_types_f pet, pay_element_types_f_tl petl
338: WHERE petl.element_type_id = pet.element_type_id
339: AND petl.LANGUAGE = USERENV('LANG')
340: AND pet.element_type_id = p_element_type_id
341: AND p_effective_date BETWEEN pet.effective_start_date