[Home] [Help]
666: l_valid varchar2(10);
667: cursor csr_find_match is
668: select 'TRUE'
669: from per_all_assignments_f asg,
670: per_work_incidents pwi,
671: hr_lookups hl
672: where p_date_earned between asg.effective_start_date
673: and asg.effective_end_date and
674: p_assignment_id = asg.assignment_id