[Home] [Help]
31: RETURN NUMBER IS
32: CURSOR c_emp_cat IS
33: SELECT nvl(paa.employee_category,'X')
34: FROM per_all_assignments_f paa,
35: pay_payroll_actions ppa
36: WHERE paa.assignment_id = p_assignment_id
37: AND ppa.payroll_action_id = p_payroll_action_id
38: AND paa.payroll_id = ppa.payroll_id
39: AND ppa.effective_date BETWEEN paa.effective_start_date
189:
190: /* This cursor returns the latest of first pay period date and contribution period start date */
191: CURSOR get_date(l_start date) IS
192: SELECT GREATEST( MIN(ppa.date_earned),l_start)
193: FROM pay_payroll_actions ppa,
194: pay_assignment_actions paa,
195: per_all_assignments_f paf
196: WHERE paf.assignment_id =p_assignment_id
197: AND paf.assignment_id=paa.assignment_id
199:
200: -- Cursor for Max Assignment Action ID for the contribution period
201: CURSOR csr_casact (l_virtual_date IN DATE) IS
202: SELECT paa.assignment_action_id
203: FROM pay_payroll_actions ppa
204: ,pay_assignment_actions paa
205: WHERE paa.payroll_action_id = ppa.payroll_action_id
206: AND paa.assignment_id = p_assignment_id
207: AND last_day(ppa.date_earned) = l_virtual_date
365:
366: /* This cursor returns the latest of first pay period date and contribution period start date */
367: CURSOR get_date(l_start date) IS
368: SELECT GREATEST( MIN(ppa.date_earned),l_start)
369: FROM pay_payroll_actions ppa,
370: pay_assignment_actions paa,
371: per_all_assignments_f paf
372: WHERE paf.assignment_id =p_assignment_id
373: AND paf.assignment_id=paa.assignment_id
968: -- The cursor to obtain the maximum payroll run date for an assignment in a BG.
969: CURSOR c_max_pay_date
970: IS
971: SELECT ppa.date_earned
972: FROM pay_payroll_actions ppa
973: ,pay_assignment_actions paa
974: WHERE ppa.payroll_action_id = paa.payroll_action_id
975: AND ppa.action_type IN ('Q','R')
976: AND ppa.action_status = 'C'