DBA Data[Home] [Help]

APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F_TL

Line 128: FROM pay_element_types_f_tl pettl,

124: CURSOR csr_eit_element_name(p_element_type_id NUMBER,
125: p_effective_date DATE)
126: IS
127: SELECT nvl(pettl.reporting_name,pettl.element_name)
128: FROM pay_element_types_f_tl pettl,
129: pay_element_types_f pet
130: WHERE pet.element_type_id = p_element_type_id
131: AND pettl.element_type_id = pet.element_type_id
132: AND pettl.language = userenv('LANG')