DBA Data[Home] [Help]

APPS.PAY_SE_FORA dependencies on PER_TIME_PERIODS

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