APPS.GHR_GHRWS52L dependencies on PER_ALL_ASSIGNMENTS_F

Line 255: from per_all_assignments_f

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