1275: and f.session_id = userenv ('sessionid');
1276:
1277: cursor csr_phones2 is
1278: select telephone_number_1 1279: from per_addresses adr, 1280: fnd_sessions f
1281: where adr.person_id = p_person_id
1282: and adr.primary_flag = 'Y'
1283: and f.effective_date between adr.date_from and