APPS.HR_ACCRUAL_PLAN_API dependencies on PAY_INPUT_VALUES_F

Line 757: pay_input_values_f piv

753: select *
754: from pay_element_links_f
755: where element_link_id in ( select pel.element_link_id
756: from pay_element_links_f pel,
757: pay_input_values_f piv
758: where pel.element_type_id = piv.element_type_id
759: and piv.input_value_id = p_pto_input_value_id
760: and p_effective_date between pel.effective_start_date
761: and pel.effective_end_date

Line 1844: UPDATE pay_input_values_f

1840: hr_utility.set_location(l_proc, 300);
1841: --
1842: -- Make PAY VALUE input value non-updateable
1843: --
1844: UPDATE pay_input_values_f
1845: SET mandatory_flag = 'X'
1846: WHERE input_value_id =
1847: ( SELECT piv.input_value_id
1848: FROM pay_input_values_f piv,

Line 1848: FROM pay_input_values_f piv,

1844: UPDATE pay_input_values_f
1845: SET mandatory_flag = 'X'
1846: WHERE input_value_id =
1847: ( SELECT piv.input_value_id
1848: FROM pay_input_values_f piv,
1849: pay_accrual_plans pap
1850: WHERE pap.accrual_plan_id = p_accrual_plan_id
1851: AND pap.accrual_plan_element_type_id = piv.element_type_id
1852: AND piv.name = 'Pay Value'

Line 2167: pay_input_values_f piv

2163: select *
2164: from pay_element_links_f
2165: where element_link_id in ( select distinct pel.element_link_id
2166: from pay_element_links_f pel,
2167: pay_input_values_f piv
2168: where pel.element_type_id = piv.element_type_id
2169: and piv.input_value_id = p_pto_input_value_id);
2170:
2171: --

Line 2649: from pay_input_values_f

2645: hr_utility.set_location(l_proc, 100);
2646:
2647: select input_value_id
2648: into l_balance_input_value_id
2649: from pay_input_values_f
2650: where element_type_id = l_plan_rec.balance_element_type_id
2651: and uom = l_uom_code;
2652:
2653: hr_utility.trace('l_balance_input_value_id: '||to_char(l_balance_input_value_id));

Line 2746: from pay_input_values_f

2742: l_formula_result_rule_id := null;
2743:
2744: select input_value_id
2745: into l_tagging_input_value_id
2746: from pay_input_values_f
2747: where element_type_id = l_plan_rec.tagging_element_type_id
2748: and uom = 'N';
2749:
2750: hr_utility.trace('l_tagging_input_value_id: '||to_char(l_tagging_input_value_id));