APPS.PAY_NZ_QES_PKG dependencies on HR_ORGANIZATION_UNITS

Line 10: (p_organization_id in hr_organization_units.organization_id%type,

6: ------------------------------------------------------------------------
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,

Line 23: (c_organization_id hr_organization_units.organization_id%type,

19:
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,

Line 75: (p_organization_id in hr_organization_units.organization_id%type,

71: -- for employee to see if the employee is part time employee or full
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,

Line 96: (c_organization_id hr_organization_units.organization_id%type,

92: v_part_time_count number(20) := 0;
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,

Line 196: (p_organization_id in hr_organization_units.organization_id%type,

192: -- Assignment are calculated, according to its Frequency and the
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,

Line 209: (c_organization_id hr_organization_units.organization_id%type,

205: v_emp_balance number(20,5) := 0;
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,