APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_PERIODS_OF_SERVICE

Line 149: select * from per_periods_of_service

145: -- Description : Modified the query of the cursor csr_period_of_svc.
146: /*cursor csr_period_of_svc
147: (p_person_id number
148: ,p_effective_date date) is
149: select * from per_periods_of_service
150: where person_id=p_person_id
151: and p_effective_date between date_start and nvl(final_process_date,p_effective_date);
152: */
153: --

Line 157: select * from per_periods_of_service

153: --
154: cursor csr_period_of_svc
155: (p_person_id number
156: ,p_effective_date date) is
157: select * from per_periods_of_service
158: where person_id=p_person_id
159: and date_start <= p_effective_date
160: order by date_start desc;
161: --

Line 447: pds_rec per_periods_of_service%rowtype;

443: l_uom pay_input_values_f.uom%type;
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;