APPS.HR_USER_INIT_DEDN dependencies on PAY_INPUT_VALUES_F

Line 516: UPDATE pay_input_values_f

512: p_third_party_pay_only => v_third_ppm);
513: --
514: v_pay_value_name := hr_input_values.get_pay_value_name(g_template_leg_code);
515: --
516: UPDATE pay_input_values_f
517: SET mandatory_flag = 'X'
518: WHERE element_type_id = ret
519: AND name = v_pay_value_name;
520: --

Line 1751: FROM pay_input_values_f IV

1747: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',80);
1748: -- We need inpval_id of pay value for this element:
1749: SELECT IV.input_value_id
1750: INTO v_er_payval_id
1751: FROM pay_input_values_f IV
1752: WHERE IV.element_type_id = p_er_charge_eletype_id
1753: AND IV.name = v_payval_name;
1754: --
1755: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',115);

Line 2224: FROM pay_input_values_f inp,

2220:
2221: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',140);
2222: SELECT inp.input_value_id
2223: INTO v_eerefund_payval_id
2224: FROM pay_input_values_f inp,
2225: hr_lookups hl
2226: WHERE inp.element_type_id = p_eerefund_eletype_id
2227: AND inp.name = hl.meaning
2228: AND hl.lookup_code = 'PAY VALUE'

Line 4401: FROM pay_input_values_f IV

4397: -- We need inpval_id of pay value for this element:
4398: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',80);
4399: SELECT IV.input_value_id
4400: INTO v_payval_id
4401: FROM pay_input_values_f IV
4402: WHERE IV.element_type_id = v_er_charge_eletype_id
4403: AND IV.name = v_payval_name;
4404: --
4405: -- Now, insert feed.

Line 4504: FROM pay_input_values_f IV

4500: -- We need inpval_id of pay value for this element:
4501: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',80);
4502: SELECT IV.input_value_id
4503: INTO v_payval_id
4504: FROM pay_input_values_f IV
4505: WHERE IV.element_type_id = v_eerefund_eletype_id
4506: AND IV.name = v_payval_name;
4507: --
4508: -- Now, insert feed.

Line 4616: FROM pay_input_values_f IV

4612: -- We need inpval_id of pay value for this element:
4613: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',80);
4614: SELECT IV.input_value_id
4615: INTO v_payval_id
4616: FROM pay_input_values_f IV
4617: WHERE IV.element_type_id = v_ele_type_id
4618: AND IV.name = v_payval_name;
4619: --
4620: -- Now, insert feed.