DBA Data[Home] [Help]

APPS.HR_360_MESSAGE dependencies on HR_LOOKUPS

Line 206: hr_lookups HL1 ,

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,

Line 207: HR_LOOKUPS HL2 ,

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 ,

Line 208: HR_LOOKUPS HL3 ,

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,

Line 209: HR_LOOKUPS HL4 ,

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,

Line 235: HR_LOOKUPS C

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'