APPS.HR_GENERATE_PRETAX dependencies on PAY_INPUT_VALUES_F

Line 2141: from pay_input_values_f

2137: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',310);
2138:
2139: select max(display_sequence)
2140: into dedn_base_seq
2141: from pay_input_values_f
2142: where element_type_id = dedn_ele_ids(1)
2143: and g_eff_start_date between effective_start_date
2144: and effective_end_date;
2145:

Line 2336: from pay_input_values_f

2332: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',310);
2333:
2334: select max(display_sequence)
2335: into dedn_wh_seq
2336: from pay_input_values_f
2337: where element_type_id = dedn_ele_ids(2)
2338: and g_eff_start_date between effective_start_date
2339: and effective_end_date;
2340:

Line 2561: from pay_input_values_f

2557: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',130);
2558:
2559: select max(display_sequence)
2560: into dedn_iv_seq
2561: from pay_input_values_f
2562: where element_type_id = dedn_ele_ids(3)
2563: and g_eff_start_date between effective_start_date
2564: and effective_end_date;
2565:

Line 2797: from pay_input_values_f

2793: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',200);
2794:
2795: select max(display_sequence)
2796: into dedn_iv_seq
2797: from pay_input_values_f
2798: where element_type_id = dedn_ele_ids(4)
2799: and g_eff_start_date between effective_start_date
2800: and effective_end_date;
2801:

Line 3015: from pay_input_values_f

3011: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',410);
3012:
3013: select max(display_sequence)
3014: into dedn_er_seq
3015: from pay_input_values_f
3016: where element_type_id = dedn_ele_ids(5)
3017: and g_eff_start_date between effective_start_date
3018: and effective_end_date;
3019:

Line 4148: UPDATE pay_input_values_f

4144: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',53);
4145:
4146: -- hr_utility.trace('Updating '||v_pay_value_name||' for '||dedn_ele_names(x));
4147:
4148: UPDATE pay_input_values_f
4149: SET mandatory_flag = 'X'
4150: WHERE element_type_id = v_ele_type_id
4151: AND name = v_pay_value_name;
4152:

Line 4155: FROM pay_input_values_f

4151: AND name = v_pay_value_name;
4152:
4153: SELECT input_value_id
4154: INTO v_payval_id
4155: FROM pay_input_values_f
4156: WHERE element_type_id = v_ele_type_id
4157: AND name = v_pay_value_name;
4158:
4159: hr_utility.set_location('hr_upgrade_earnings. upgrade_template',157);