APPS.CSE_PROJ_ITEM_IN_SRV_PKG dependencies on CSI_A_LOCATIONS

Line 33: FROM csi_a_locations

29: l_hz_or_hr varchar2(1);
30:
31: CURSOR loc_map_cur(p_location_table IN varchar2) IS
32: SELECT fa_location_id
33: FROM csi_a_locations
34: WHERE location_table in (p_location_table , 'LOCATION_CODES')
35: AND location_id = p_location_id
36: AND sysdate BETWEEN nvl(active_start_date, sysdate - 1)
37: AND nvl(active_end_date, sysdate + 1);