APPS.PER_JP_CTR_UTILITY_PKG dependencies on PER_ALL_PEOPLE_F

Line 118: -- per_all_people_f per

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

Line 140: -- from per_all_people_f per2

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

Line 195: per_all_people_f per,

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

Line 226: from per_all_people_f per2

222: or (
223: per.effective_start_date = per.start_date
224: and not exists(
225: select null
226: from per_all_people_f per2
227: where per2.person_id = per.person_id
228: and l_effective_date
229: between per2.effective_start_date and per2.effective_end_date)
230: )