APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_ALL_ASSIGNMENTS_F

Line 225: from per_all_assignments_f

221: cursor csr_assignment_details
222: (p_assignment_id number
223: ,p_effective_date date) is
224: select *
225: from per_all_assignments_f
226: where assignment_id=p_assignment_id
227: and p_effective_date between effective_start_date and effective_end_date;
228: --
229: cursor csr_asg_status

Line 450: asg_rec per_all_assignments_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;
453: pyp_rec per_pay_proposals%rowtype;
454: dpf_rec per_deployment_factors%rowtype;