APPS.OKL_TAL_PVT dependencies on OKX_ASST_BK_CONTROLS_V

Line 1028: -- Description : FK validation with OKX_ASST_BK_CONTROLS_V

1024: ------------------------------19----------------------------------------------
1025: -- Start of Commnets
1026: -- Badrinath Kuchibholta
1027: -- Procedure Name : validate_corp_book
1028: -- Description : FK validation with OKX_ASST_BK_CONTROLS_V
1029: -- Business Rules :
1030: -- Parameters : OUT Return Status, IN Rec Info
1031: -- Version : 1.0
1032: -- End of Commnets

Line 1038: CURSOR c_corp_book_validate(p_name OKX_ASST_BK_CONTROLS_V.NAME%TYPE) is

1034: PROCEDURE validate_corp_book(x_return_status OUT NOCOPY VARCHAR2,
1035: p_talv_rec IN talv_rec_type) IS
1036:
1037: ln_dummy number := 0;
1038: CURSOR c_corp_book_validate(p_name OKX_ASST_BK_CONTROLS_V.NAME%TYPE) is
1039: SELECT 1
1040: FROM DUAL
1041: WHERE EXISTS (SELECT id1
1042: FROM OKX_ASST_BK_CONTROLS_V

Line 1042: FROM OKX_ASST_BK_CONTROLS_V

1038: CURSOR c_corp_book_validate(p_name OKX_ASST_BK_CONTROLS_V.NAME%TYPE) is
1039: SELECT 1
1040: FROM DUAL
1041: WHERE EXISTS (SELECT id1
1042: FROM OKX_ASST_BK_CONTROLS_V
1043: WHERE name = p_name
1044: AND book_class = 'CORPORATE');
1045:
1046: BEGIN