[Home] [Help]
2: /* $Header: pynzqes.pkh 115.4 2003/05/30 08:27:36 puchil ship $ */
3:
4: function count_employees
5: (p_organization_id in hr_organization_units.organization_id%type,
6: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
7: p_time_period_id in per_time_periods.time_period_id%type,
8: p_location_id in per_all_assignments_f.location_id%type,
9: p_emp_cat_code in per_all_people_f.per_information7%type,
10: p_work_time_code in per_all_people_f.per_information8%type,
13: return number;
14:
15: function count_employees_using_balance
16: (p_organization_id in hr_organization_units.organization_id%type,
17: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
18: p_time_period_id in per_time_periods.time_period_id%type,
19: p_location_id in per_all_assignments_f.location_id%type,
20: p_emp_cat_code in per_all_people_f.per_information7%type,
21: p_work_time_code in per_all_people_f.per_information8%type,
26: return number;
27:
28: function sum_balances
29: (p_organization_id in hr_organization_units.organization_id%type,
30: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
31: p_time_period_id in per_time_periods.time_period_id%type,
32: p_location_id in per_all_assignments_f.location_id%type,
33: p_defined_balance_id in pay_defined_balances.defined_balance_id%type,
34: p_sex in per_all_people_f.sex%type,
46: return number;
47:
48: function hours_worked
49: (p_assignment_id in per_all_assignments_f.assignment_id%type,
50: p_payroll_frequency in pay_all_payrolls_f.period_type%type)
51: return number;
52:
53: function convert_hours
54: (p_assignment_hours in per_all_assignments_f.normal_hours%type,
51: return number;
52:
53: function convert_hours
54: (p_assignment_hours in per_all_assignments_f.normal_hours%type,
55: p_payroll_frequency in pay_all_payrolls_f.period_type%type,
56: p_assignment_frequency in per_all_assignments_f.frequency%type)
57: return number;
58:
59: function no_periods_per_year