DBA Data[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on CSI_A_LOCATIONS

Line 512: FROM csi_a_locations

508: l_hz_or_hr varchar2(1);
509:
510: CURSOR loc_map_cur(p_location_table IN varchar2) IS
511: SELECT fa_location_id
512: FROM csi_a_locations
513: WHERE location_table in ('LOCATION_CODES', p_location_table)
514: AND location_id = p_location_id
515: AND sysdate BETWEEN nvl(active_start_date, sysdate - 1)
516: AND nvl(active_end_date, sysdate + 1);