561: )
562: is
563: select addr.postal_code,
564: addr.date_from
565: from per_addresses addr
566: where addr.person_id = p_contact_person_id
567: and addr.primary_flag = 'Y'
568: and (c_effective_date >= addr.date_from
569: or addr.date_from is null)
577: )
578: is
579: select addr.postal_code,
580: addr.date_from
581: from per_addresses addr
582: where addr.person_id = l_contact.person_id
583: and addr.primary_flag = 'Y'
584: and (c_effective_date >= addr.date_from
585: or addr.date_from is null)