APPS.PER_JP_CTR_UTILITY_PKG dependencies on PER_ALL_PEOPLE_F

Line 119: -- per_all_people_f per

115: -- nvl(least(per.date_of_death, l_effective_date), l_effective_date) EFFECTIVE_DATE,
116: -- to_number(ctr.cont_information2) SEQUENCE
117: -- from per_all_assignments_f asg,
118: -- per_contact_relationships ctr,
119: -- per_all_people_f per
120: -- where asg.assignment_id = p_assignment_id
121: -- and l_effective_date
122: -- between asg.effective_start_date and asg.effective_end_date
123: -- and ctr.person_id = asg.person_id

Line 141: -- from per_all_people_f per2

137: -- or (
138: -- per.effective_start_date = per.start_date
139: -- and not exists(
140: -- select null
141: -- from per_all_people_f per2
142: -- where per2.person_id = per.person_id
143: -- and l_effective_date
144: -- between per2.effective_start_date and per2.effective_end_date)
145: -- )

Line 198: per_all_people_f per,

194: per.first_name FIRST_NAME_KANA
195: from per_all_assignments_f asg,
196: per_contact_relationships ctr,
197: per_contact_extra_info_f cei,
198: per_all_people_f per,
199: hr_lookups hrl1,
200: hr_lookups hrl2
201: where asg.assignment_id = p_assignment_id
202: and l_effective_date

Line 222: from per_all_people_f per2

218: between per.effective_start_date and per.effective_end_date)
219: or (per.effective_start_date = per.start_date
220: and not exists(
221: select null
222: from per_all_people_f per2
223: where per2.person_id = per.person_id
224: and l_effective_date
225: between per2.effective_start_date and per2.effective_end_date)))
226: and hrl1.lookup_type = 'CONTACT'