DBA Data[Home] [Help]

APPS.HR_AU_SUPER_API dependencies on PAY_INPUT_VALUES_F

Line 186: (p_element_type_id pay_input_values_f.element_type_id%type

182: --
183: l_procedure constant varchar2(60) := 'get_super_input_ids';
184: --
185: cursor csr_super_input_values
186: (p_element_type_id pay_input_values_f.element_type_id%type
187: ,p_effective_date date
188: ) is
189: select piv.input_value_id
190: , piv.name

Line 191: from pay_input_values_f piv

187: ,p_effective_date date
188: ) is
189: select piv.input_value_id
190: , piv.name
191: from pay_input_values_f piv
192: where piv.element_type_id = p_element_type_id
193: and p_effective_date between piv.effective_start_date and piv.effective_end_date;
194: --
195: cursor csr_super_element