38: from per_addresses addr
39: where addr.person_id = p_person_id
40: and ( addr.primary_flag = 'Y'
41: or addr.primary_flag is null)
42: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
43: and nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
44:
45: end;
39: where addr.person_id = p_person_id
40: and ( addr.primary_flag = 'Y'
41: or addr.primary_flag is null)
42: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
43: and nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
44:
45: end;