APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_PERIODS_OF_SERVICE

Line 178: select * from per_periods_of_service

174: -- Description : Modified the query of the cursor csr_period_of_svc.
175: /*cursor csr_period_of_svc
176: (p_person_id number
177: ,p_effective_date date) is
178: select * from per_periods_of_service
179: where person_id=p_person_id
180: and p_effective_date between date_start and nvl(final_process_date,p_effective_date);
181: */
182: --

Line 186: select * from per_periods_of_service

182: --
183: cursor csr_period_of_svc
184: (p_person_id number
185: ,p_effective_date date) is
186: select * from per_periods_of_service
187: where person_id=p_person_id
188: and date_start <= p_effective_date
189: order by date_start desc;
190: --

Line 477: pds_rec per_periods_of_service%rowtype;

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