[Home] [Help]
268: ,p_user_col_id => ln_user_col_id
269: ,p_bg_id => p_bg_id
270: ,p_date_earned => p_date_earned);
271: FETCH get_user_col_values INTO ln_value;
272: ln_std_hrs_wrksch := ln_std_hrs_wrksch + fnd_number.canonical_to_number(ln_value);
273: CLOSE get_user_col_values;
274:
275: END LOOP;
276: CLOSE get_user_rows;
1120: v_entrange_start DATE; -- max of entry or asst range start
1121: v_entrange_end DATE; -- min of entry or asst range end
1122: v_work_schedule VARCHAR2(60); -- Work Schedule ID (stored as varchar2
1123: -- in HR_SOFT_CODING_KEYFLEX; convert
1124: -- fnd_number.canonical_to_number when calling wshours fn.
1125: v_work_sched_name VARCHAR2(80);
1126: v_ws_id NUMBER(9);
1127:
1128: b_entries_done BOOLEAN; -- flags no more entry changes in paypd
1249: hr_utility.trace('Getting WORK SCHEDULE Name');
1250:
1251: -- Get work schedule name:
1252:
1253: v_ws_id := fnd_number.canonical_to_number(p_wsched);
1254:
1255: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
1256:
1257: SELECT user_column_name
1609: l_vac_hours NUMBER(10,7);
1610:
1611: CURSOR get_vac_hours ( v_asg_id NUMBER,
1612: v_eff_date DATE) IS
1613: select fnd_number.canonical_to_number(pev.screen_entry_value)
1614: from per_absence_attendance_types abt,
1615: pay_element_entries_f pee,
1616: pay_element_entry_values_f pev
1617: where pev.input_value_id = abt.input_value_id
1675: l_sick_hours NUMBER(10,7);
1676:
1677: CURSOR get_sick_hours ( v_asg_id NUMBER,
1678: v_eff_date DATE) IS
1679: select fnd_number.canonical_to_number(pev.screen_entry_value)
1680: from per_absence_attendance_types abt,
1681: pay_element_entries_f pee,
1682: pay_element_entry_values_f pev
1683: where pev.input_value_id = abt.input_value_id
2005: --
2006: hr_utility.trace('Asg has Work Schedule');
2007: hr_utility.trace('p_work_schedule ='||p_work_schedule);
2008:
2009: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);
2010: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
2011: --
2012: SELECT user_column_name
2013: INTO v_work_sched_name
2617:
2618: hr_utility.trace('BOTH ASG Get latest screen entry value for EEVMPE');
2619: hr_utility.set_location('calculate_period_earnings', 128);
2620:
2621: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2622: INTO v_earnings_entry
2623: FROM pay_element_entry_values_f EEV
2624: WHERE EEV.element_entry_id = p_ele_entry_id
2625: AND EEV.input_value_id = v_inpval_id
2702:
2703: hr_utility.trace('NO EEVMPE changes');
2704: hr_utility.set_location('calculate_period_earnings', 132);
2705:
2706: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2707: INTO v_earnings_entry
2708: FROM pay_element_entry_values_f EEV
2709: WHERE EEV.element_entry_id = p_ele_entry_id
2710: AND EEV.input_value_id = v_inpval_id
2809:
2810: -- EEV_FOR_CURR_RANGE_END
2811:
2812: hr_utility.trace('BOTH ASG - EEV false');
2813: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2814: INTO v_earnings_entry
2815: FROM pay_element_entry_values_f EEV
2816: WHERE EEV.element_entry_id = p_ele_entry_id
2817: AND EEV.input_value_id = v_inpval_id
2919:
2920: hr_utility.trace('BOTH ASG SPAN - SELECT EEV_FOR_CURR_RANGE_END');
2921: hr_utility.set_location('calculate_period_earnings', 165);
2922:
2923: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2924: INTO v_earnings_entry
2925: FROM pay_element_entry_values_f EEV
2926: WHERE EEV.element_entry_id = p_ele_entry_id
2927: AND EEV.input_value_id = v_inpval_id
3083:
3084: CURSOR get_salary (l_date_earned date,
3085: l_assignment_id number,
3086: l_input_value_id number) IS
3087: select fnd_number.canonical_to_number (EEV.screen_entry_value)
3088: from pay_element_entries_f EE
3089: , pay_element_entry_values_f EEV
3090: where EEV.input_value_id = l_input_value_id
3091: and l_date_earned BETWEEN EEV.effective_start_date
4141:
4142: /*
4143: CURSOR get_sick_hours ( v_asg_id NUMBER,
4144: v_eff_date DATE) IS
4145: select fnd_number.canonical_to_number(pev.screen_entry_value)
4146: from per_absence_attendance_types abt,
4147: pay_element_entries_f pee,
4148: pay_element_entry_values_f pev
4149: where pev.input_value_id = abt.input_value_id
4162: select distinct pee.element_entry_id
4163: ,abs.absence_attendance_id
4164: ,abs.date_start
4165: ,abs.date_end
4166: ,fnd_number.canonical_to_number(peev.screen_entry_value)
4167: from per_absence_attendance_types abt
4168: ,per_absence_attendances abs
4169: ,pay_element_entries_f pee
4170: ,pay_element_entry_values_f peev
4274:
4275: /*
4276: CURSOR get_vac_hours ( v_asg_id NUMBER,
4277: v_eff_date DATE) IS
4278: select fnd_number.canonical_to_number(pev.screen_entry_value)
4279: from per_absence_attendance_types abt,
4280: pay_element_entries_f pee,
4281: pay_element_entry_values_f pev
4282: where pev.input_value_id = abt.input_value_id
4295: select distinct pee.element_entry_id
4296: ,abs.absence_attendance_id
4297: ,abs.date_start
4298: ,abs.date_end
4299: ,fnd_number.canonical_to_number(peev.screen_entry_value)
4300: from per_absence_attendance_types abt
4301: ,per_absence_attendances abs
4302: ,pay_element_entries_f pee
4303: ,pay_element_entry_values_f peev