DBA Data[Home] [Help]

APPS.HR_HRHD_INITIAL_LOAD dependencies on HR_LOCATIONS_ALL_TL

Line 82: hr_locations_all hloc,hr_locations_all_tl tl

78: LOC_INFORMATION18,
79: LOC_INFORMATION19,
80: LOC_INFORMATION20
81: from
82: hr_locations_all hloc,hr_locations_all_tl tl
83: where tl.location_id = hloc.location_id
84: and nvl(inactive_date,to_date('31/12/4712','DD/MM/YYYY')) > sysdate
85: union
86: select hloc.BUSINESS_GROUP_ID,

Line 114: hr_locations_all hloc,hr_locations_all_tl tl

110: LOC_INFORMATION18,
111: LOC_INFORMATION19,
112: LOC_INFORMATION20
113: from
114: hr_locations_all hloc,hr_locations_all_tl tl
115: where tl.location_id = hloc.location_id
116: and inactive_date is not null
117: order by business_group_id,location_id ;
118: