APPS.GHR_DS_JAN99_PKG dependencies on HR_LOCATION_EXTRA_INFO

Line 70: from hr_location_extra_info a,

66:
67:
68: cursor cur_old_ds is
69: select b.duty_station_code old_duty_station_code
70: from hr_location_extra_info a,
71: ghr_duty_stations_f b
72: where information_type = 'GHR_US_LOC_INFORMATION'
73: and a.lei_information3 = b.duty_station_id
74: and b.duty_station_code in

Line 89: from hr_location_extra_info a,

85: and a.location_id = p_old_location_id;
86:
87: cursor cur_new_ds is
88: select b.duty_station_code new_duty_station_code
89: from hr_location_extra_info a,
90: ghr_duty_stations_f b
91: where information_type = 'GHR_US_LOC_INFORMATION'
92: and a.lei_information3 = b.duty_station_id
93: and b.duty_station_code in