DBA Data[Home] [Help]

APPS.HR_US_GARN_GEN dependencies on PAY_INPUT_VALUES_F

Line 2443: UPDATE pay_input_values_f

2439:
2440: v_pay_value_name := hr_input_values.get_pay_value_name(g_template_leg_code);
2441:
2442: begin
2443: UPDATE pay_input_values_f
2444: SET mandatory_flag = 'X'
2445: WHERE element_type_id = v_ele_type_id
2446: AND name = v_pay_value_name;
2447: if sql%notfound then

Line 2455: FROM pay_input_values_f

2451:
2452: begin
2453: SELECT input_value_id
2454: INTO v_payval_id
2455: FROM pay_input_values_f
2456: WHERE element_type_id = v_ele_type_id
2457: AND name = v_pay_value_name
2458: AND g_eff_end_date between effective_start_date
2459: and effective_end_date; /*1498260*/