APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_ADDRESSES

Line 211: from per_addresses

207: cursor csr_addresses
208: (p_person_id number
209: ,p_effective_date date) is
210: select *
211: from per_addresses
212: where person_id=p_person_id
213: and primary_flag='Y'
214: and p_effective_date between date_from and nvl(date_to,p_effective_date);
215: --

Line 479: addr_rec per_addresses%rowtype;

475: per_rec per_all_people_f%rowtype;
476: app_rec per_applications%rowtype;
477: pds_rec per_periods_of_service%rowtype;
478: pdp_rec per_periods_of_placement%rowtype;
479: addr_rec per_addresses%rowtype;
480: asg_rec per_all_assignments_f%rowtype;
481: pgp_rec pay_people_groups%rowtype;
482: scl_rec hr_soft_coding_keyflex%rowtype;
483: pyp_rec per_pay_proposals%rowtype;