DBA Data[Home] [Help]

APPS.PAY_SE_FORA dependencies on PER_TIME_PERIODS

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