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 1836: UPDATE pay_input_values_f

1832: hr_utility.set_location(l_proc, 300);
1833: --
1834: -- Make PAY VALUE input value non-updateable
1835: --
1836: UPDATE pay_input_values_f
1837: SET mandatory_flag = 'X'
1838: WHERE input_value_id =
1839: ( SELECT piv.input_value_id
1840: FROM pay_input_values_f piv,

Line 1840: FROM pay_input_values_f piv,

1836: UPDATE pay_input_values_f
1837: SET mandatory_flag = 'X'
1838: WHERE input_value_id =
1839: ( SELECT piv.input_value_id
1840: FROM pay_input_values_f piv,
1841: pay_accrual_plans pap
1842: WHERE pap.accrual_plan_id = p_accrual_plan_id
1843: AND pap.accrual_plan_element_type_id = piv.element_type_id
1844: AND piv.name = 'Pay Value'

Line 2159: pay_input_values_f piv

2155: select *
2156: from pay_element_links_f
2157: where element_link_id in ( select distinct pel.element_link_id
2158: from pay_element_links_f pel,
2159: pay_input_values_f piv
2160: where pel.element_type_id = piv.element_type_id
2161: and piv.input_value_id = p_pto_input_value_id);
2162:
2163: --

Line 2641: from pay_input_values_f

2637: hr_utility.set_location(l_proc, 100);
2638:
2639: select input_value_id
2640: into l_balance_input_value_id
2641: from pay_input_values_f
2642: where element_type_id = l_plan_rec.balance_element_type_id
2643: and uom = l_uom_code;
2644:
2645: hr_utility.trace('l_balance_input_value_id: '||to_char(l_balance_input_value_id));

Line 2738: from pay_input_values_f

2734: l_formula_result_rule_id := null;
2735:
2736: select input_value_id
2737: into l_tagging_input_value_id
2738: from pay_input_values_f
2739: where element_type_id = l_plan_rec.tagging_element_type_id
2740: and uom = 'N';
2741:
2742: hr_utility.trace('l_tagging_input_value_id: '||to_char(l_tagging_input_value_id));