DBA Data[Home] [Help]

APPS.HRDYNDBI dependencies on PAY_INPUT_VALUES_F_TL

Line 8574: , pay_input_values_f_tl ivtl

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
8578: and ettl.element_type_id = iv.element_type_id

Line 8585: l_ipv_name pay_input_values_f_tl.name%type;

8581: and ivtl.language = p_language
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

Line 9652: -- Interface 1: does not reference PAY_INPUT_VALUES_F_TL - the core

9648: -- Update all the dbis for an input value --
9649: -- ====================================== --
9650:
9651: --
9652: -- Interface 1: does not reference PAY_INPUT_VALUES_F_TL - the core
9653: -- interface.
9654: --
9655: procedure update_input_value
9656: (p_input_value_id in number

Line 10095: -- Interface 2: references PAY_INPUT_VALUES_F_TL.

10091:
10092: end update_input_value;
10093:
10094: --
10095: -- Interface 2: references PAY_INPUT_VALUES_F_TL.
10096: --
10097: procedure update_input_value
10098: (p_input_value_id in number
10099: ,p_effective_date in date