APPS.JL_CO_NIT_LIBRARY_1_PKG dependencies on JL_CO_GL_NIT_ACCTS

Line 5: nit_reqd jl_co_gl_nit_accts.nit_required%TYPE;

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

Line 9: FROM JL_CO_GL_NIT_ACCTS

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);