DBA Data[Home] [Help]

APPS.HR_HRHD_INITIAL_LOAD dependencies on HR_LOCATIONS_ALL_TL

Line 70: hr_locations_all hloc,hr_locations_all_tl tl

66: LOC_INFORMATION18,
67: LOC_INFORMATION19,
68: LOC_INFORMATION20
69: from
70: hr_locations_all hloc,hr_locations_all_tl tl
71: where tl.location_id = hloc.location_id
72: and nvl(inactive_date,to_date('31/12/4712','DD/MM/YYYY')) > sysdate
73: union
74: select hloc.BUSINESS_GROUP_ID,

Line 102: hr_locations_all hloc,hr_locations_all_tl tl

98: LOC_INFORMATION18,
99: LOC_INFORMATION19,
100: LOC_INFORMATION20
101: from
102: hr_locations_all hloc,hr_locations_all_tl tl
103: where tl.location_id = hloc.location_id
104: and inactive_date is not null
105: order by business_group_id,location_id ;
106: