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