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.

APPS.HR_DELTA_SYNC_MESSAGES dependencies on HR_LOOKUPS

Line 962: hr_lookups HL1 ,

958:
959: FROM PER_ALL_PEOPLE_F ppf,
960: PER_ADDRESSES padr ,
961: PER_PHONES ppn ,
962: hr_lookups HL1 ,
963: HR_LOOKUPS HL2 ,
964: HR_LOOKUPS HL3 ,
965: HR_LOOKUPS HL4
966: WHERE ppf.person_id = padr.person_id (+)

Line 963: HR_LOOKUPS HL2 ,

959: FROM PER_ALL_PEOPLE_F ppf,
960: PER_ADDRESSES padr ,
961: PER_PHONES ppn ,
962: hr_lookups HL1 ,
963: HR_LOOKUPS HL2 ,
964: HR_LOOKUPS HL3 ,
965: HR_LOOKUPS HL4
966: WHERE ppf.person_id = padr.person_id (+)
967: AND ( padr.person_id is null

Line 964: HR_LOOKUPS HL3 ,

960: PER_ADDRESSES padr ,
961: PER_PHONES ppn ,
962: hr_lookups HL1 ,
963: HR_LOOKUPS HL2 ,
964: HR_LOOKUPS HL3 ,
965: HR_LOOKUPS HL4
966: WHERE ppf.person_id = padr.person_id (+)
967: AND ( padr.person_id is null
968: OR ( padr.person_id is not null

Line 965: HR_LOOKUPS HL4

961: PER_PHONES ppn ,
962: hr_lookups HL1 ,
963: HR_LOOKUPS HL2 ,
964: HR_LOOKUPS HL3 ,
965: HR_LOOKUPS HL4
966: WHERE ppf.person_id = padr.person_id (+)
967: AND ( padr.person_id is null
968: OR ( padr.person_id is not null
969: AND padr.primary_flag ='Y'

Line 1076: hr_lookups HL1 ,

1072:
1073: FROM PER_ALL_PEOPLE_F ppf,
1074: PER_ADDRESSES padr ,
1075: PER_PHONES ppn ,
1076: hr_lookups HL1 ,
1077: HR_LOOKUPS HL2 ,
1078: HR_LOOKUPS HL3 ,
1079: HR_LOOKUPS HL4
1080: WHERE ppf.person_id = padr.person_id (+)

Line 1077: HR_LOOKUPS HL2 ,

1073: FROM PER_ALL_PEOPLE_F ppf,
1074: PER_ADDRESSES padr ,
1075: PER_PHONES ppn ,
1076: hr_lookups HL1 ,
1077: HR_LOOKUPS HL2 ,
1078: HR_LOOKUPS HL3 ,
1079: HR_LOOKUPS HL4
1080: WHERE ppf.person_id = padr.person_id (+)
1081: AND ( padr.person_id is null

Line 1078: HR_LOOKUPS HL3 ,

1074: PER_ADDRESSES padr ,
1075: PER_PHONES ppn ,
1076: hr_lookups HL1 ,
1077: HR_LOOKUPS HL2 ,
1078: HR_LOOKUPS HL3 ,
1079: HR_LOOKUPS HL4
1080: WHERE ppf.person_id = padr.person_id (+)
1081: AND ( padr.person_id is null
1082: OR ( padr.person_id is not null

Line 1079: HR_LOOKUPS HL4

1075: PER_PHONES ppn ,
1076: hr_lookups HL1 ,
1077: HR_LOOKUPS HL2 ,
1078: HR_LOOKUPS HL3 ,
1079: HR_LOOKUPS HL4
1080: WHERE ppf.person_id = padr.person_id (+)
1081: AND ( padr.person_id is null
1082: OR ( padr.person_id is not null
1083: AND padr.primary_flag ='Y'