APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_APPLICATIONS

Line 140: select * from per_applications

136: --
137: cursor csr_application
138: (p_person_id number
139: ,p_effective_date date) is
140: select * from per_applications
141: where person_id=p_person_id
142: and p_effective_date between date_received and nvl(date_end,p_effective_date);
143: --
144: -- Bug 3540524 Starts here

Line 446: app_rec per_applications%rowtype;

442: --
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;