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