APPS.BEN_ASSIGNMENT_INTERNAL dependencies on PER_ADDRESSES

Line 571: l_add_dets per_addresses%ROWTYPE;

567: ,p_divorce in boolean
568: )
569: is
570: --
571: l_add_dets per_addresses%ROWTYPE;
572: --
573: l_ctr_shdresflg varchar2(100);
574: l_ctr_id number;
575: l_ctr_ovn number;

Line 597: from per_addresses adr

593: (c_per_id in number
594: )
595: Is
596: select *
597: from per_addresses adr
598: where adr.person_id = c_per_id
599: and adr.primary_flag = 'Y'
600: and p_benasg_effdate between adr.date_from and nvl(adr.date_to,p_benasg_effdate)
601: order by adr.date_from desc ;