APPS.CSE_ASSET_CREATION_PKG dependencies on CSI_A_LOCATIONS

Line 528: FROM csi_a_locations

524: l_hz_or_hr varchar2(1);
525:
526: CURSOR loc_map_cur(p_location_table IN varchar2) IS
527: SELECT fa_location_id
528: FROM csi_a_locations
529: WHERE location_table in ('LOCATION_CODES', p_location_table)
530: AND location_id = p_location_id
531: AND sysdate BETWEEN nvl(active_start_date, sysdate - 1)
532: AND nvl(active_end_date, sysdate + 1);