DBA Data[Home] [Help]

APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on PER_ADDRESSES

Line 565: from per_addresses addr

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)

Line 581: from per_addresses addr

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)