DBA Data[Home] [Help]

APPS.JA_JAINJVR_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 17: GL_SETS_OF_BOOKS

13: CURSOR FOR_SOB_NAME(SOB_ID IN NUMBER) IS
14: SELECT
15: NAME
16: FROM
17: GL_SETS_OF_BOOKS
18: WHERE SET_OF_BOOKS_ID = SOB_ID;
19: V_NAME VARCHAR2(100);
20: BEGIN
21: OPEN FOR_SOB_NAME(P_SOB_ID);

Line 152: gl_sets_of_books gsob

148: SELECT count(*) INTO v_count
149: FROM gl_je_headers gjh,
150: gl_je_lines gjl,
151: gl_code_combinations gcc,
152: gl_sets_of_books gsob
153: WHERE gjh.je_header_id = gjl.je_header_id
154: AND gcc.code_combination_id = gjl.code_combination_id
155: AND gsob.set_of_books_id = gjh.ledger_id
156: AND gjh.je_source = NVL(p_source, gjh.je_source)