999: FUNCTION Is_Reporting_Books (
1000: p_set_of_books_id IN NUMBER)
1001: RETURN BOOLEAN IS
1002:
1003: l_set_of_books_type gl_sets_of_books.mrc_sob_type_code%TYPE;
1004:
1005: BEGIN
1006:
1007: SELECT mrc_sob_type_code
1005: BEGIN
1006:
1007: SELECT mrc_sob_type_code
1008: INTO l_set_of_books_type
1009: FROM gl_sets_of_books
1010: WHERE set_of_books_id = p_set_of_books_id;
1011:
1012: IF l_set_of_books_type = 'R' THEN
1013: RETURN TRUE;