APPS.CSI_ASSET_VLD_PVT dependencies on CSI_A_LOCATIONS

Line 327: /* exists in csi_a_locations */

323:
324: /*-----------------------------------------------------------*/
325: /* Procedure name: Is_Asset_Location_Valid */
326: /* Description : Check if the instance location id */
327: /* exists in csi_a_locations */
328: /*-----------------------------------------------------------*/
329:
330: FUNCTION Is_Asset_Location_Valid
331: ( p_location_id IN NUMBER,

Line 339: FROM csi_a_locations

335: l_return_value BOOLEAN := TRUE;
336: BEGIN
337: SELECT 'x'
338: INTO l_dummy
339: FROM csi_a_locations
340: WHERE fa_location_id = p_location_id
341: and ((active_end_date is null) OR (active_end_date >= sysdate))
342: and ROWNUM = 1;
343: