[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
191:
192: /* This cursor returns the latest of first pay period date and contribution period start date */
193: CURSOR get_date(l_start date) IS
194: SELECT GREATEST( MIN(ppa.date_earned),l_start)
195: FROM pay_payroll_actions ppa,
196: pay_assignment_actions paa,
197: per_all_assignments_f paf
198: WHERE paf.assignment_id =p_assignment_id
199: AND paf.assignment_id=paa.assignment_id
201:
202: -- Cursor for Max Assignment Action ID for the contribution period
203: CURSOR csr_casact (l_virtual_date IN DATE) IS
204: SELECT paa.assignment_action_id
205: FROM pay_payroll_actions ppa
206: ,pay_assignment_actions paa
207: WHERE paa.payroll_action_id = ppa.payroll_action_id
208: AND paa.assignment_id = p_assignment_id
209: AND last_day(ppa.date_earned) = l_virtual_date
371:
372: /* This cursor returns the latest of first pay period date and contribution period start date */
373: CURSOR get_date(l_start date) IS
374: SELECT GREATEST( MIN(ppa.date_earned),l_start)
375: FROM pay_payroll_actions ppa,
376: pay_assignment_actions paa,
377: per_all_assignments_f paf
378: WHERE paf.assignment_id =p_assignment_id
379: AND paf.assignment_id=paa.assignment_id
974: -- The cursor to obtain the maximum payroll run date for an assignment in a BG.
975: CURSOR c_max_pay_date
976: IS
977: SELECT ppa.date_earned
978: FROM pay_payroll_actions ppa
979: ,pay_assignment_actions paa
980: WHERE ppa.payroll_action_id = paa.payroll_action_id
981: AND ppa.action_type IN ('Q','R')
982: AND ppa.action_status = 'C'