APPS.PQH_PSF_BUS dependencies on PAY_INPUT_VALUES_F

Line 4745: pay_input_values_f piv

4741: p_effective_date date) is
4742: select piv.element_type_id, ppb.input_value_id
4743: from per_all_assignments_f asg,
4744: per_pay_bases ppb,
4745: pay_input_values_f piv
4746: where assignment_id = p_assignment_id
4747: and asg.pay_basis_id = ppb.pay_basis_id
4748: and ppb.input_value_id = piv.input_value_id
4749: and p_effective_date between asg.effective_start_date and asg.effective_end_date

Line 4778: from pay_input_values_f_tl pivtl

4774:
4775: function decode_input_value(p_input_value_id number) return varchar2 is
4776: cursor c_input_value_name(p_input_value_id number) is
4777: select pivtl.name
4778: from pay_input_values_f_tl pivtl
4779: where pivtl.input_value_id = p_input_value_id
4780: and pivtl.language = userenv('LANG');
4781: --
4782: l_input_value_name pay_input_values_f_tl.name%type;

Line 4782: l_input_value_name pay_input_values_f_tl.name%type;

4778: from pay_input_values_f_tl pivtl
4779: where pivtl.input_value_id = p_input_value_id
4780: and pivtl.language = userenv('LANG');
4781: --
4782: l_input_value_name pay_input_values_f_tl.name%type;
4783: begin
4784: open c_input_value_name(p_input_value_id);
4785: fetch c_input_value_name into l_input_value_name;
4786: close c_input_value_name;