eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HR_FULL_SYNC_MESSAGES dependencies on HR_LOOKUPS

Line 513: hr_lookups HL1 ,

509:
510: FROM PER_ALL_PEOPLE_F ppf,
511: PER_ADDRESSES padr ,
512: PER_PHONES ppn ,
513: hr_lookups HL1 ,
514: HR_LOOKUPS HL2 ,
515: HR_LOOKUPS HL3 ,
516: HR_LOOKUPS HL4
517: WHERE ppf.person_id = padr.person_id (+)

Line 514: HR_LOOKUPS HL2 ,

510: FROM PER_ALL_PEOPLE_F ppf,
511: PER_ADDRESSES padr ,
512: PER_PHONES ppn ,
513: hr_lookups HL1 ,
514: HR_LOOKUPS HL2 ,
515: HR_LOOKUPS HL3 ,
516: HR_LOOKUPS HL4
517: WHERE ppf.person_id = padr.person_id (+)
518: AND ( padr.person_id is null

Line 515: HR_LOOKUPS HL3 ,

511: PER_ADDRESSES padr ,
512: PER_PHONES ppn ,
513: hr_lookups HL1 ,
514: HR_LOOKUPS HL2 ,
515: HR_LOOKUPS HL3 ,
516: HR_LOOKUPS HL4
517: WHERE ppf.person_id = padr.person_id (+)
518: AND ( padr.person_id is null
519: OR ( padr.person_id is not null

Line 516: HR_LOOKUPS HL4

512: PER_PHONES ppn ,
513: hr_lookups HL1 ,
514: HR_LOOKUPS HL2 ,
515: HR_LOOKUPS HL3 ,
516: HR_LOOKUPS HL4
517: WHERE ppf.person_id = padr.person_id (+)
518: AND ( padr.person_id is null
519: OR ( padr.person_id is not null
520: AND padr.primary_flag ='Y'