APPS.HR_USER_INIT_DEDN dependencies on PAY_INPUT_VALUES_F

Line 504: UPDATE pay_input_values_f

500: p_third_party_pay_only => v_third_ppm);
501: --
502: v_pay_value_name := hr_input_values.get_pay_value_name(g_template_leg_code);
503: --
504: UPDATE pay_input_values_f
505: SET mandatory_flag = 'X'
506: WHERE element_type_id = ret
507: AND name = v_pay_value_name;
508: --

Line 1739: FROM pay_input_values_f IV

1735: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',80);
1736: -- We need inpval_id of pay value for this element:
1737: SELECT IV.input_value_id
1738: INTO v_er_payval_id
1739: FROM pay_input_values_f IV
1740: WHERE IV.element_type_id = p_er_charge_eletype_id
1741: AND IV.name = v_payval_name;
1742: --
1743: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',115);

Line 2212: FROM pay_input_values_f inp,

2208:
2209: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',140);
2210: SELECT inp.input_value_id
2211: INTO v_eerefund_payval_id
2212: FROM pay_input_values_f inp,
2213: hr_lookups hl
2214: WHERE inp.element_type_id = p_eerefund_eletype_id
2215: AND inp.name = hl.meaning
2216: AND hl.lookup_code = 'PAY VALUE'

Line 4293: FROM pay_input_values_f IV

4289: -- We need inpval_id of pay value for this element:
4290: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',80);
4291: SELECT IV.input_value_id
4292: INTO v_payval_id
4293: FROM pay_input_values_f IV
4294: WHERE IV.element_type_id = v_er_charge_eletype_id
4295: AND IV.name = v_payval_name;
4296: --
4297: -- Now, insert feed.

Line 4396: FROM pay_input_values_f IV

4392: -- We need inpval_id of pay value for this element:
4393: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',80);
4394: SELECT IV.input_value_id
4395: INTO v_payval_id
4396: FROM pay_input_values_f IV
4397: WHERE IV.element_type_id = v_eerefund_eletype_id
4398: AND IV.name = v_payval_name;
4399: --
4400: -- Now, insert feed.

Line 4508: FROM pay_input_values_f IV

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