1180: IS
1181:
1182: CURSOR csr_cwk_start_date IS
1183: SELECT date_start
1184: FROM per_periods_of_placement
1185: WHERE actual_termination_date is null OR
1186: (trunc(sysdate) < actual_termination_date);
1187:
1188: l_date_start per_periods_of_placement.date_start%type;
1184: FROM per_periods_of_placement
1185: WHERE actual_termination_date is null OR
1186: (trunc(sysdate) < actual_termination_date);
1187:
1188: l_date_start per_periods_of_placement.date_start%type;
1189:
1190: BEGIN
1191:
1192: OPEN csr_cwk_start_date;