DBA Data[Home] [Help]

APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F_TL

Line 126: FROM pay_element_types_f_tl pettl,

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