DBA Data[Home] [Help]

APPS.HR_ENTRY_DISPLAY dependencies on PAY_ELEMENT_TYPES_F_TL

Line 51: l_element_name pay_element_types_f_tl.element_name%type;

47: FUNCTION original_entry_name
48: (p_original_entry_id in number
49: ) return varchar2
50: is
51: l_element_name pay_element_types_f_tl.element_name%type;
52: --
53: cursor csr_element_name
54: is
55: select

Line 60: ,pay_element_types_f_tl pettl

56: pettl.element_name
57: from
58: pay_element_entries_f pee
59: ,pay_element_links_f pel
60: ,pay_element_types_f_tl pettl
61: where
62: pee.element_entry_id = p_original_entry_id
63: and pel.element_link_id = pee.element_link_id
64: and pee.effective_start_date between pel.effective_start_date