APPS.JL_ZZ_AP_LIBRARY_1_PKG dependencies on HR_LOCATIONS_ALL

Line 242: from hr_locations_all

238: Begin
239: errcd := 0;
240: select to_number(global_attribute2)
241: Into ccid
242: from hr_locations_all
243: where location_id = locn_id and rownum = row_number;
244: Exception
245: When Others Then
246: errcd := sqlcode;

Line 429: from hr_locations_all

425: Begin
426: errcd := 0;
427: select substr(region_2,1,30)
428: into shp_to
429: from hr_locations_all
430: where location_id = locn_id and rownum = row_number;
431: Exception
432: When Others Then
433: errcd := sqlcode;