DBA Data[Home] [Help]

APPS.PQH_PSF_BUS dependencies on PAY_ELEMENT_TYPES_F_TL

Line 4375: from pay_element_types_f_tl pettl1

4371:
4372: function decode_element(p_element_type_id number) return varchar2 is
4373: cursor c_element_name(p_element_type_id number) is
4374: select pettl1.element_name
4375: from pay_element_types_f_tl pettl1
4376: where pettl1.element_type_id = p_element_type_id
4377: and pettl1.language = userenv('LANG');
4378: --
4379: l_element_name pay_element_types_f_tl.element_name%type;

Line 4379: l_element_name pay_element_types_f_tl.element_name%type;

4375: from pay_element_types_f_tl pettl1
4376: where pettl1.element_type_id = p_element_type_id
4377: and pettl1.language = userenv('LANG');
4378: --
4379: l_element_name pay_element_types_f_tl.element_name%type;
4380: begin
4381: open c_element_name(p_element_type_id);
4382: fetch c_element_name into l_element_name;
4383: close c_element_name;