DBA Data[Home] [Help]

APPS.OKL_TAS_PVT dependencies on HR_OPERATING_UNITS

Line 299: -- Description : FK validation with HR_OPERATING_UNITS

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

Line 313: FROM HR_OPERATING_UNITS

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;