327: l_assignment_exists varchar2(1);
328: --
329: cursor csr_assignment_exists is
330: select 'x' 331: from dual 332: where exists (select 1
333: from per_all_assignments_f paa
334: where p_rec.assignment_id = paa.assignment_id
335: and p_rec.effective_date between paa.effective_start_date
[Home] [Help]