DBA Data[Home] [Help]

APPS.PAY_ELEMENT_DATA_PUMP dependencies on PAY_ELEMENT_TYPES_F_TL

Line 599: l_element_name pay_element_types_f_tl.ELEMENT_NAME%type;

595: )
596: return number is
597:
598: l_input_value_id number;
599: l_element_name pay_element_types_f_tl.ELEMENT_NAME%type;
600:
601: Begin
602: select pettl.element_name
603: into l_element_name

Line 605: pay_element_types_f_tl pettl,

601: Begin
602: select pettl.element_name
603: into l_element_name
604: from pay_element_types_f pet,
605: pay_element_types_f_tl pettl,
606: hr_pump_batch_line_user_keys
607: where pettl.language = p_language_code
608: and pet.element_type_id = pettl.element_type_id
609: and p_effective_date between