DBA Data[Home] [Help]

APPS.OKL_TAS_PVT dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 21: -- Description : FK validation with OKX_CUSTOMER_ACCOUNTS_V

17: -------------------------------------------------------------------------------------
18: -- Start of Commnets
19: -- Badrinath Kuchibholta
20: -- Procedure Name : Validate_ica_id
21: -- Description : FK validation with OKX_CUSTOMER_ACCOUNTS_V
22: -- Business Rules :
23: -- Parameters : OUT Return Status, IN Rec Info
24: -- Version : 1.0
25: -- End of Commnets

Line 35: FROM OKX_CUSTOMER_ACCOUNTS_V

31: IS
32: SELECT 1
33: FROM DUAL
34: WHERE EXISTS (SELECT ID1
35: FROM OKX_CUSTOMER_ACCOUNTS_V
36: WHERE id1 = p_id
37: AND id2 = G_ID2);
38: BEGIN
39: -- initialize return status