202:
203: FROM PER_ALL_PEOPLE_F ppf,
204: PER_ALL_PEOPLE_F ppf1,
205: PER_PHONES ppn ,
206: hr_lookups HL1 ,
207: HR_LOOKUPS HL2 ,
208: HR_LOOKUPS HL3 ,
209: HR_LOOKUPS HL4 ,
210: PER_ALL_ASSIGNMENTS_F PA,
203: FROM PER_ALL_PEOPLE_F ppf,
204: PER_ALL_PEOPLE_F ppf1,
205: PER_PHONES ppn ,
206: hr_lookups HL1 ,
207: HR_LOOKUPS HL2 ,
208: HR_LOOKUPS HL3 ,
209: HR_LOOKUPS HL4 ,
210: PER_ALL_ASSIGNMENTS_F PA,
211: PER_GRADES PG ,
204: PER_ALL_PEOPLE_F ppf1,
205: PER_PHONES ppn ,
206: hr_lookups HL1 ,
207: HR_LOOKUPS HL2 ,
208: HR_LOOKUPS HL3 ,
209: HR_LOOKUPS HL4 ,
210: PER_ALL_ASSIGNMENTS_F PA,
211: PER_GRADES PG ,
212: PER_JOBS J,
205: PER_PHONES ppn ,
206: hr_lookups HL1 ,
207: HR_LOOKUPS HL2 ,
208: HR_LOOKUPS HL3 ,
209: HR_LOOKUPS HL4 ,
210: PER_ALL_ASSIGNMENTS_F PA,
211: PER_GRADES PG ,
212: PER_JOBS J,
213: PER_GRADES_TL GDT,
231: PCR1.CONTACT_PERSON_ID
232:
233: FROM PER_ALL_PEOPLE_F PPF1 ,
234: PER_CONTACT_RELATIONSHIPS PCR1 ,
235: HR_LOOKUPS C
236:
237: WHERE PPF1.PERSON_ID = CONTACT_PERSON_ID
238: AND PRIMARY_CONTACT_FLAG = 'Y'
239: AND C.LOOKUP_TYPE = 'CONTACT'