1627: and ast.per_system_status = 'TERM_CWK_ASG';
1628: --
1629: cursor csr_get_period_end_date is
1630: select tpe.end_date
1631: from per_time_periods tpe
1632: where tpe.payroll_id = l_payroll_id
1633: and l_actual_termination_date between tpe.start_date
1634: and tpe.end_date;
1635: --
2537: and ast.per_system_status = 'TERM_ASSIGN';
2538: --
2539: cursor csr_get_period_end_date is
2540: select tpe.end_date
2541: from per_time_periods tpe
2542: where tpe.payroll_id = l_payroll_id
2543: and l_actual_termination_date between tpe.start_date
2544: and tpe.end_date;
2545: --