APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_PERIODS_OF_PLACEMENT

Line 170: select * from per_periods_of_placement

166: --
167: cursor csr_period_of_placement
168: (p_person_id number
169: ,p_effective_date date) is
170: select * from per_periods_of_placement
171: where person_id=p_person_id
172: and date_start <= p_effective_date
173: order by date_start desc;
174: /*and p_effective_date between date_start and nvl(actual_termination_date,p_effective_date);*/

Line 448: pdp_rec per_periods_of_placement%rowtype;

444: --
445: per_rec per_all_people_f%rowtype;
446: app_rec per_applications%rowtype;
447: pds_rec per_periods_of_service%rowtype;
448: pdp_rec per_periods_of_placement%rowtype;
449: addr_rec per_addresses%rowtype;
450: asg_rec per_all_assignments_f%rowtype;
451: pgp_rec pay_people_groups%rowtype;
452: scl_rec hr_soft_coding_keyflex%rowtype;