APPS.PQH_PSF_BUS dependencies on PAY_INPUT_VALUES_F

Line 4357: pay_input_values_f piv

4353: p_effective_date date) is
4354: select piv.element_type_id, ppb.input_value_id
4355: from per_all_assignments_f asg,
4356: per_pay_bases ppb,
4357: pay_input_values_f piv
4358: where assignment_id = p_assignment_id
4359: and asg.pay_basis_id = ppb.pay_basis_id
4360: and ppb.input_value_id = piv.input_value_id
4361: and p_effective_date between asg.effective_start_date and asg.effective_end_date

Line 4390: from pay_input_values_f_tl pivtl

4386:
4387: function decode_input_value(p_input_value_id number) return varchar2 is
4388: cursor c_input_value_name(p_input_value_id number) is
4389: select pivtl.name
4390: from pay_input_values_f_tl pivtl
4391: where pivtl.input_value_id = p_input_value_id
4392: and pivtl.language = userenv('LANG');
4393: --
4394: l_input_value_name pay_input_values_f_tl.name%type;

Line 4394: l_input_value_name pay_input_values_f_tl.name%type;

4390: from pay_input_values_f_tl pivtl
4391: where pivtl.input_value_id = p_input_value_id
4392: and pivtl.language = userenv('LANG');
4393: --
4394: l_input_value_name pay_input_values_f_tl.name%type;
4395: begin
4396: open c_input_value_name(p_input_value_id);
4397: fetch c_input_value_name into l_input_value_name;
4398: close c_input_value_name;