APPS.GHR_GHRWS52L dependencies on PER_ALL_ASSIGNMENTS_F

Line 260: from per_all_assignments_f

256: ORDER BY 1 desc;
257: -- New cursor for non correction actions
258: cursor c_prior_ds_date_non_correct(p_assignment_id in number) is
259: select effective_start_date
260: from per_all_assignments_f
261: where assignment_id = p_assignment_id
262: and p_pa_request_rec.effective_date between
263: effective_start_date and nvl(effective_end_date,trunc(sysdate))
264: order by effective_start_date desc;