295: -------------------------------------------------------------------------------------
296: -- Start of Commnets
297: -- Bug # 2697681 - 11.5.9 schema changes avsingh
298: -- Procedure Name : Validate_org_id
299: -- Description : FK validation with HR_OPERATING_UNITS
300: -- Business Rules :
301: -- Parameters : OUT Return Status, IN Rec Info
302: -- Version : 1.0
303: -- End of Commnets
309: IS
310: SELECT 1
311: FROM DUAL
312: WHERE EXISTS (SELECT Organization_id
313: FROM HR_OPERATING_UNITS
314: WHERE Organization_id = p_id);
315: BEGIN
316: -- initialize return status
317: x_return_status := OKC_API.G_RET_STS_SUCCESS;