[Home] [Help]
39: p_term_health_contrib out nocopy varchar2
40: ) return number is
41:
42: cursor csr_payroll_end_date is
43: select end_date from per_time_periods where
44: payroll_id = p_payroll_id
45: and p_date_earned between start_date and end_date;
46:
47: cursor csr_date_terminated is
50: per_assignment_status_types past1,
51: per_all_assignments_f paaf2,
52: per_assignment_status_types past2,
53: pay_all_payrolls_f papf,
54: per_time_periods ptp
55: where past1.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
56: and paaf1.assignment_status_type_id=past1.assignment_status_type_id
57: and paaf1.assignment_id=p_assignment_id
58: and past2.per_system_status ='TERM_ASSIGN'
325: p_ir_flag out nocopy varchar2
326: ) return number is
327: cursor csr_payroll_end_date is
328: select end_date
329: from per_time_periods
330: where payroll_id = p_payroll_id
331: and p_date_earned between start_date and end_date;
332:
333: cursor csr_date_terminated is
336: per_assignment_status_types past1,
337: per_all_assignments_f paaf2,
338: per_assignment_status_types past2,
339: pay_all_payrolls_f papf,
340: per_time_periods ptp
341: where past1.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
342: and paaf1.assignment_status_type_id=past1.assignment_status_type_id
343: and paaf1.assignment_id=p_assignment_id
344: and past2.per_system_status ='TERM_ASSIGN'
355: cursor csr_payroll_run (r_assignment_id number,r_date date,r_payroll_id number,r_less_than_date date) is
356: select 'Y' payroll_run,paa.assignment_action_id ,ppa.date_earned
357: from pay_payroll_actions ppa,
358: pay_Assignment_actions paa,
359: per_time_periods ptp,
360: pay_all_payrolls_f papf,
361: pay_run_results prr,
362: pay_element_types_f petf
363: where paa.source_action_id is not null