DBA Data[Home] [Help]

APPS.HR_360_MESSAGE dependencies on HR_LOOKUPS

Line 203: hr_lookups HL1 ,

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,

Line 204: HR_LOOKUPS HL2 ,

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 ,

Line 205: HR_LOOKUPS HL3 ,

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,

Line 206: HR_LOOKUPS HL4 ,

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,

Line 232: HR_LOOKUPS C

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'