APPS.PQH_COMMITMENT_PKG dependencies on PAY_INPUT_VALUES_F

Line 1567: select name from pay_input_values_f piv

1563: -- This cursor get the input value name for a given input value id.
1564: Cursor csr_get_input_value_name( p_input_value_id in number,
1565: p_commit_calculation_dt in date,
1566: p_commit_calculation_end_dt in date) is
1567: select name from pay_input_values_f piv
1568: where piv.input_value_id = p_input_value_id
1569: --and p_commit_calculation_dt between piv.effective_start_date and piv.effective_start_date;
1570: and piv.effective_end_date > p_commit_calculation_dt
1571: and piv.effective_start_date <= p_commit_calculation_end_dt ;

Line 1786: , pay_input_values_f piv --To ensure that this input value id belongs to the passed element_type

1782: p_commit_calculation_dt in date,
1783: p_commit_calculation_end_dt in date) is
1784: Select ppb.pay_basis,ppb.input_value_id
1785: from per_pay_bases ppb
1786: , pay_input_values_f piv --To ensure that this input value id belongs to the passed element_type
1787: where ppb.pay_basis_id = p_pay_basis_id
1788: and piv.input_value_id = ppb.input_value_id
1789: and piv.element_type_id = p_element_type_id
1790: and piv.effective_start_date <= p_commit_calculation_end_dt

Line 3745: , pay_input_values_f piv --To ensure that this input value id belongs to the passed element_type

3741: AND effective_end_date;
3742: Cursor csr_salary_basis(p_pay_basis_id number) is
3743: Select ppb.input_value_id
3744: from per_pay_bases ppb
3745: , pay_input_values_f piv --To ensure that this input value id belongs to the passed element_type
3746: where ppb.pay_basis_id = p_pay_basis_id
3747: and piv.input_value_id = ppb.input_value_id
3748: and piv.element_type_id = p_element_type_id
3749: and p_effective_date between piv.effective_start_date and piv.effective_end_date;