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