Line 1038: from per_all_people_f where person_id = p_resource_id
1034:
1035: elsif contact_type ='E' then
1036: select email_address
1037: into ret_val 1038: from per_all_people_f where person_id = p_resource_id 1039: and sysdate between effective_start_date and effective_end_date;
1040: end if;
1041: return ret_val;
1042: