APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_A_LOCATIONS

Line 1668: /* exists in csi_a_locations */

1664:
1665: /*-----------------------------------------------------------*/
1666: /* Procedure name: Is_Asset_Location_Valid */
1667: /* Description : Check if the instance location id */
1668: /* exists in csi_a_locations */
1669: /*-----------------------------------------------------------*/
1670:
1671: FUNCTION Is_Asset_Location_Valid
1672: ( p_location_id IN NUMBER,

Line 1680: FROM csi_a_locations

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