[Home] [Help]
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,
16: p_sex in per_all_people_f.sex%type,
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,
29: c_sex per_all_people_f.sex%type,
31: is
32: select count(*)
33: from hr_soft_coding_keyflex hsck,
34: pay_payrolls_f pay, /*Bug 2920728*/
35: per_time_periods ptp,
36: per_people_f pap, /*Bug 2920728*/
37: per_assignments_f paa /*Bug 2920728*/
38: where hsck.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
39: and hsck.segment1 = to_char(c_organization_id)
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,
81: p_sex in per_all_people_f.sex%type,
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,
102: c_survey_date date) is
108: paa.assignment_id,
109: c_defined_balance_id) balance
110: from hr_soft_coding_keyflex hsck,
111: pay_payrolls_f pay, /*Bug 2929728*/
112: per_time_periods ptp,
113: per_people_f pap, /*Bug 2920728*/
114: per_assignments_f paa /*Bug 2920728*/
115: where hsck.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
116: and hsck.segment1 = to_char(c_organization_id)
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,
202: p_survey_date in date)
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,
215: c_survey_date date) is
221: paa.assignment_id,
222: c_defined_balance_id) balance
223: from hr_soft_coding_keyflex hsck,
224: pay_payrolls_f pay, /*Bug 2920728*/
225: per_time_periods ptp,
226: per_people_f pap, /*Bug 2920728*/
227: per_assignments_f paa /*Bug 2920728*/
228: where hsck.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
229: and hsck.segment1 = to_char(c_organization_id)
316: -- Returns the Balance for the Ordinary Time Payout for the Effective
317: -- Date and Assignment.
318: ------------------------------------------------------------------------
319: function ordinary_time_payout
320: (p_regular_payment_date in per_time_periods.regular_payment_date%type,
321: p_assignment_id in per_all_assignments_f.assignment_id%type)
322: return number is
323:
324: v_payout number(20,5) := 0;