APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_A_LOCATIONS

Line 1664: /* exists in csi_a_locations */

1660:
1661: /*-----------------------------------------------------------*/
1662: /* Procedure name: Is_Asset_Location_Valid */
1663: /* Description : Check if the instance location id */
1664: /* exists in csi_a_locations */
1665: /*-----------------------------------------------------------*/
1666:
1667: FUNCTION Is_Asset_Location_Valid
1668: ( p_location_id IN NUMBER,

Line 1676: FROM csi_a_locations

1672: l_return_value BOOLEAN := TRUE;
1673: BEGIN
1674: SELECT 'x'
1675: INTO l_dummy
1676: FROM csi_a_locations
1677: WHERE location_id = p_location_id
1678: and ((active_end_date is null) OR (active_end_date >= sysdate));
1679:
1680: RETURN l_return_value;