Line 484: SELECT START_DATE,end_date FROM per_time_periods WHERE payroll_id=csr_v_payroll_id --3469
480: AND hoi2.org_information_context = 'SE_LOCAL_UNIT_DETAILS';
481:
482: CURSOR csr_payroll_periods(csr_v_effective_date date,csr_v_payroll_id number)
483: IS 484: SELECT START_DATE,end_date FROM per_time_periods WHERE payroll_id=csr_v_payroll_id --3469 485: AND /*'15-jan-2005'*/ csr_v_effective_date BETWEEN START_DATE AND end_date;
486:
487: CURSOR csr_white_collar_from (csr_v_assignment_start_date DATE,csr_v_assignment_id NUMBER )
488: IS