APPS.PAY_ELEMENT_DATA_PUMP dependencies on PAY_ELEMENT_TYPES_F

Line 348: From pay_element_classifications ec, pay_element_types_f et

344:
345: Begin
346: Select et.element_type_id
347: INTO l_element_type_id
348: From pay_element_classifications ec, pay_element_types_f et
349: Where ec.classification_id = et.classification_id
350: and p_effective_date between et.effective_start_date and
351: et.effective_end_date
352: and nvl(et.legislation_code,

Line 477: From pay_element_types_f pet,

473: --
474: Begin
475: Select pet.object_version_number
476: into l_element_type_ovn
477: From pay_element_types_f pet,
478: hr_pump_batch_line_user_keys key
479: Where key.user_key_value = p_element_type_user_key
480: and pet.element_type_id = key.unique_key_id
481: and p_effective_date between

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 604: from pay_element_types_f pet,

600:
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

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