[Home] [Help]
741: v_entrange_start DATE; -- max of entry or asst range start
742: v_entrange_end DATE; -- min of entry or asst range end
743: v_work_schedule VARCHAR2(60); -- Work Schedule ID (stored as varchar2
744: -- in HR_SOFT_CODING_KEYFLEX; convert
745: -- fnd_number.canonical_to_number when calling wshours fn.
746: v_work_sched_name VARCHAR2(80);
747: v_ws_id NUMBER(9);
748:
749: b_entries_done BOOLEAN; -- flags no more entry changes in paypd
870: hr_utility.trace('Getting WORK SCHEDULE Name');
871:
872: -- Get work schedule name:
873:
874: v_ws_id := fnd_number.canonical_to_number(p_wsched);
875:
876: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
877:
878: SELECT user_column_name
1230: l_vac_hours NUMBER(10,7);
1231:
1232: CURSOR get_vac_hours ( v_asg_id NUMBER,
1233: v_eff_date DATE) IS
1234: select fnd_number.canonical_to_number(pev.screen_entry_value)
1235: from per_absence_attendance_types abt,
1236: pay_element_entries_f pee,
1237: pay_element_entry_values_f pev
1238: where pev.input_value_id = abt.input_value_id
1296: l_sick_hours NUMBER(10,7);
1297:
1298: CURSOR get_sick_hours ( v_asg_id NUMBER,
1299: v_eff_date DATE) IS
1300: select fnd_number.canonical_to_number(pev.screen_entry_value)
1301: from per_absence_attendance_types abt,
1302: pay_element_entries_f pee,
1303: pay_element_entry_values_f pev
1304: where pev.input_value_id = abt.input_value_id
1626: --
1627: hr_utility.trace('Asg has Work Schedule');
1628: hr_utility.trace('p_work_schedule ='||p_work_schedule);
1629:
1630: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);
1631: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
1632: --
1633: SELECT user_column_name
1634: INTO v_work_sched_name
2208:
2209: hr_utility.trace('BOTH ASG Get latest screen entry value for EEVMPE');
2210: hr_utility.set_location('calculate_period_earnings', 128);
2211:
2212: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2213: INTO v_earnings_entry
2214: FROM pay_element_entry_values_f EEV
2215: WHERE EEV.element_entry_id = p_ele_entry_id
2216: AND EEV.input_value_id = v_inpval_id
2293:
2294: hr_utility.trace('NO EEVMPE changes');
2295: hr_utility.set_location('calculate_period_earnings', 132);
2296:
2297: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2298: INTO v_earnings_entry
2299: FROM pay_element_entry_values_f EEV
2300: WHERE EEV.element_entry_id = p_ele_entry_id
2301: AND EEV.input_value_id = v_inpval_id
2400:
2401: -- EEV_FOR_CURR_RANGE_END
2402:
2403: hr_utility.trace('BOTH ASG - EEV false');
2404: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2405: INTO v_earnings_entry
2406: FROM pay_element_entry_values_f EEV
2407: WHERE EEV.element_entry_id = p_ele_entry_id
2408: AND EEV.input_value_id = v_inpval_id
2510:
2511: hr_utility.trace('BOTH ASG SPAN - SELECT EEV_FOR_CURR_RANGE_END');
2512: hr_utility.set_location('calculate_period_earnings', 165);
2513:
2514: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2515: INTO v_earnings_entry
2516: FROM pay_element_entry_values_f EEV
2517: WHERE EEV.element_entry_id = p_ele_entry_id
2518: AND EEV.input_value_id = v_inpval_id
2674:
2675: CURSOR get_salary (l_date_earned date,
2676: l_assignment_id number,
2677: l_input_value_id number) IS
2678: select fnd_number.canonical_to_number (EEV.screen_entry_value)
2679: from pay_element_entries_f EE
2680: , pay_element_entry_values_f EEV
2681: where EEV.input_value_id = l_input_value_id
2682: and l_date_earned BETWEEN EEV.effective_start_date