[Home] [Help]
7: -- Counts the number of people per group.
8: ------------------------------------------------------------------------
9: function count_employees
10: (p_organization_id in hr_organization_units.organization_id%type,
11: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
12: p_time_period_id in per_time_periods.time_period_id%type,
13: p_location_id in per_all_assignments_f.location_id%type,
14: p_emp_cat_code in per_all_people_f.per_information7%type,
15: p_work_time_code in per_all_people_f.per_information8%type,
20: v_emp_count number(20) := 0;
21:
22: cursor emp_count
23: (c_organization_id hr_organization_units.organization_id%type,
24: c_payroll_id pay_all_payrolls_f.payroll_id%type,
25: c_time_period_id per_time_periods.time_period_id%type,
26: c_location_id per_all_assignments_f.location_id%type,
27: c_emp_cat_code per_all_people_f.per_information7%type,
28: c_work_time_code per_all_people_f.per_information8%type,
72: -- time employee
73: ------------------------------------------------------------------------
74: function count_employees_using_balance
75: (p_organization_id in hr_organization_units.organization_id%type,
76: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
77: p_time_period_id in per_time_periods.time_period_id%type,
78: p_location_id in per_all_assignments_f.location_id%type,
79: p_emp_cat_code in per_all_people_f.per_information7%type,
80: p_work_time_code in per_all_people_f.per_information8%type,
93: v_standard_hours number(20) := 0;
94:
95: cursor emp_balance
96: (c_organization_id hr_organization_units.organization_id%type,
97: c_payroll_id pay_all_payrolls_f.payroll_id%type,
98: c_time_period_id per_time_periods.time_period_id%type,
99: c_location_id per_all_assignments_f.location_id%type,
100: c_defined_balance_id pay_defined_balances.defined_balance_id%type,
101: c_sex per_all_people_f.sex%type,
193: -- Payroll Frequency.
194: ------------------------------------------------------------------------
195: function sum_balances
196: (p_organization_id in hr_organization_units.organization_id%type,
197: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
198: p_time_period_id in per_time_periods.time_period_id%type,
199: p_location_id in per_all_assignments_f.location_id%type,
200: p_defined_balance_id in pay_defined_balances.defined_balance_id%type,
201: p_sex in per_all_people_f.sex%type,
206: v_total_balance number(20,5) := 0;
207:
208: cursor emp_balance
209: (c_organization_id hr_organization_units.organization_id%type,
210: c_payroll_id pay_all_payrolls_f.payroll_id%type,
211: c_time_period_id per_time_periods.time_period_id%type,
212: c_location_id per_all_assignments_f.location_id%type,
213: c_defined_balance_id pay_defined_balances.defined_balance_id%type,
214: c_sex per_all_people_f.sex%type,
341: -- convert_hours.
342: ------------------------------------------------------------------------
343: function hours_worked
344: (p_assignment_id in per_all_assignments_f.assignment_id%type,
345: p_payroll_frequency in pay_all_payrolls_f.period_type%type)
346: return number is
347:
348: v_hours_worked number(20,5) := 0;
349:
386: -- year.
387: ------------------------------------------------------------------------
388: function convert_hours
389: (p_assignment_hours in per_all_assignments_f.normal_hours%type,
390: p_payroll_frequency in pay_all_payrolls_f.period_type%type,
391: p_assignment_frequency in per_all_assignments_f.frequency%type)
392: return number is
393:
394: v_converted_hours number(20,5) := 0;