[Home] [Help]
360:
361: /* This cursor returns the Disable Proof */
362: Cursor c_disab_details(l_esi_cont_date date) is
363: select pdf.dis_information1
364: from per_disabilities_f pdf,
365: per_all_assignments_f paa
366: where paa.assignment_id = p_assignment_id
367: and paa.person_id = pdf.person_id
368: and l_esi_cont_date between paa.effective_start_date and paa.effective_end_date