DBA Data[Home] [Help]

APPS.OKL_ITI_PVT dependencies on OKL_TXL_ASSETS_V

Line 118: -- Description : FK validation with OKL_TXL_ASSETS_V

114: -------------------------------2--------------------------------------------------
115: -- Start of Commnets
116: -- Badrinath Kuchibholta
117: -- Procedure Name : Validate_tal_id
118: -- Description : FK validation with OKL_TXL_ASSETS_V
119: -- Business Rules :
120: -- Parameters : OUT Return Status, IN Rec Info
121: -- Version : 1.0
122: -- End of Commnets

Line 131: FROM OKL_TXL_ASSETS_V

127: CURSOR c_tal_id_validate(p_id number) is
128: SELECT 1
129: FROM DUAL
130: WHERE EXISTS (SELECT '1'
131: FROM OKL_TXL_ASSETS_V
132: WHERE id = p_id);
133:
134: BEGIN
135: -- initialize return status