1503: p_session_date in date ) is
1504: l_dummy number ;
1505: cursor c1 is
1506: select 1 1507: from per_people_f 1508: where person_id = p_person_id
1509: and current_applicant_flag = 'Y'
1510: and p_session_date
1511: between effective_start_date and effective_end_date ;