APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_ALL_PEOPLE_F

Line 23: from per_business_groups x , per_all_people_f papf

19: cursor csr_bg_name
20: (p_person_id number,
21: p_effective_date date) is
22: select x.name
23: from per_business_groups x , per_all_people_f papf
24: where x.business_group_id = papf.business_group_id
25: and papf.person_id=p_person_id;
26: --
27: --Added for PMxbg

Line 99: from per_all_people_f

95: (p_person_id number
96: ,p_effective_date date) is
97:
98: select *
99: from per_all_people_f
100: where person_id=p_person_id
101: and p_effective_date between effective_start_date and effective_end_date;
102: --
103: cursor csr_person_type

Line 194: and parent_table='PER_ALL_PEOPLE_F'

190: ,p_effective_date date) is
191: select 0,phone_id,date_from,date_to,phone_number,object_version_number
192: from per_phones
193: where parent_id=p_person_id
194: and parent_table='PER_ALL_PEOPLE_F'
195: and phone_type=p_type
196: and p_effective_date between date_from and nvl(date_to,p_effective_date)
197: UNION
198: select months_between(p_effective_date,date_to),phone_id,date_from,date_to,phone_number,object_version_number

Line 201: and parent_table='PER_ALL_PEOPLE_F'

197: UNION
198: select months_between(p_effective_date,date_to),phone_id,date_from,date_to,phone_number,object_version_number
199: from per_phones
200: where parent_id=p_person_id
201: and parent_table='PER_ALL_PEOPLE_F'
202: and phone_type=p_type
203: and p_effective_date>date_to
204: UNION
205: select months_between(date_from,p_effective_date),phone_id,date_from,date_to,phone_number,object_version_number

Line 208: and parent_table='PER_ALL_PEOPLE_F'

204: UNION
205: select months_between(date_from,p_effective_date),phone_id,date_from,date_to,phone_number,object_version_number
206: from per_phones
207: where parent_id=p_person_id
208: and parent_table='PER_ALL_PEOPLE_F'
209: and phone_type=p_type
210: and p_effective_date 211: order by 1;
212: --

Line 445: per_rec per_all_people_f%rowtype;

441: l_rate_rec csr_asg_rates%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;