5096:
5097: begin
5098: select PHONE.phone_number
5099: into l_employee_phone_no
5100: from per_phones PHONE ,
5101: fnd_sessions SES
5102: where PHONE.parent_id (+) = l_person_id
5103: and PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'
5104: and PHONE.phone_type (+)= 'W1'