PACKAGE BODY: APPS.JL_CO_NIT_LIBRARY_1_PKG

Source

1 PACKAGE BODY jl_co_nit_library_1_pkg AS
2 /* $Header: jlconl1b.pls 115.2 99/08/03 20:07:45 porting ship $ */
3 
4 FUNCTION nit_required (account VARCHAR2, sob_id NUMBER) return Varchar2 IS
5   nit_reqd jl_co_gl_nit_accts.nit_required%TYPE;
6 BEGIN
7 
8   SELECT nit_required INTO nit_reqd
9   FROM JL_CO_GL_NIT_ACCTS
10   WHERE account_code = account and
11         chart_of_accounts_id = (SELECT chart_of_accounts_id
12                                 FROM   gl_sets_of_books
13                                 WHERE  set_of_books_id = sob_id);
14   RETURN NVL(nit_reqd,'N');
15   Exception When Others THEN
16              RETURN 'N';
17 
18 END nit_required;
19 
20 END jl_co_nit_library_1_pkg;