APPS.PQH_PSF_BUS dependencies on PAY_ELEMENT_TYPES_F_TL

Line 4763: from pay_element_types_f_tl pettl1

4759:
4760: function decode_element(p_element_type_id number) return varchar2 is
4761: cursor c_element_name(p_element_type_id number) is
4762: select pettl1.element_name
4763: from pay_element_types_f_tl pettl1
4764: where pettl1.element_type_id = p_element_type_id
4765: and pettl1.language = userenv('LANG');
4766: --
4767: l_element_name pay_element_types_f_tl.element_name%type;

Line 4767: l_element_name pay_element_types_f_tl.element_name%type;

4763: from pay_element_types_f_tl pettl1
4764: where pettl1.element_type_id = p_element_type_id
4765: and pettl1.language = userenv('LANG');
4766: --
4767: l_element_name pay_element_types_f_tl.element_name%type;
4768: begin
4769: open c_element_name(p_element_type_id);
4770: fetch c_element_name into l_element_name;
4771: close c_element_name;