DBA Data[Home] [Help]

APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on PER_ADDRESSES

Line 557: from per_addresses addr

553: )
554: is
555: select addr.postal_code,
556: addr.date_from
557: from per_addresses addr
558: where addr.person_id = p_contact_person_id
559: and addr.primary_flag = 'Y'
560: and (c_effective_date >= addr.date_from
561: or addr.date_from is null)

Line 573: from per_addresses addr

569: )
570: is
571: select addr.postal_code,
572: addr.date_from
573: from per_addresses addr
574: where addr.person_id = l_contact.person_id
575: and addr.primary_flag = 'Y'
576: and (c_effective_date >= addr.date_from
577: or addr.date_from is null)