APPS.HRDYNDBI dependencies on PAY_ELEMENT_TYPES_F_TL

Line 8519: from pay_element_types_f_tl ettl

8515: (p_element_type_id in number
8516: ,p_language in varchar2
8517: ) is
8518: select ettl.element_name
8519: from pay_element_types_f_tl ettl
8520: where ettl.element_type_id = p_element_type_id
8521: and ettl.language = p_language
8522: ;
8523: --

Line 8573: , pay_element_types_f_tl ettl

8569: ) is
8570: select ivtl.name
8571: , ettl.element_name
8572: from pay_input_values_f iv
8573: , pay_element_types_f_tl ettl
8574: , pay_input_values_f_tl ivtl
8575: where iv.input_value_id = p_input_value_id
8576: and p_effective_date between
8577: iv.effective_start_date and iv.effective_end_date

Line 8586: l_ele_name pay_element_types_f_tl.element_name%type;

8582: ;
8583: --
8584: l_pay_value pay_input_values_f.name%type := null;
8585: l_ipv_name pay_input_values_f_tl.name%type;
8586: l_ele_name pay_element_types_f_tl.element_name%type;
8587: l_found boolean := true;
8588: l_debug boolean := hr_utility.debug_enabled;
8589: begin
8590: --

Line 9184: -- Interface 1: does not reference PAY_ELEMENT_TYPES_F_TL - the core

9180: -- Update dbis for an element type --
9181: -- =============================== --
9182:
9183: --
9184: -- Interface 1: does not reference PAY_ELEMENT_TYPES_F_TL - the core
9185: -- interface.
9186: --
9187: procedure update_element_type
9188: (p_element_type_id in number

Line 9618: -- Interface 2: references PAY_ELEMENT_TYPES_F_TL.

9614:
9615: end update_element_type;
9616:
9617: --
9618: -- Interface 2: references PAY_ELEMENT_TYPES_F_TL.
9619: --
9620: procedure update_element_type
9621: (p_element_type_id in number
9622: ,p_effective_date in date