APPS.ZX_ZXARRECV_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 34: L_SET_OF_BOOKS_ID APPS.GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;

30: ERRBUF VARCHAR2(2000);
31: RETCODE NUMBER;
32: INIT_FAILURE EXCEPTION;
33: DUMMY VARCHAR2(1000);
34: L_SET_OF_BOOKS_ID APPS.GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
35: L_PERIOD_FROM APPS.GL_PERIOD_STATUSES.PERIOD_NAME%TYPE;
36: L_PERIOD_TO APPS.GL_PERIOD_STATUSES.PERIOD_NAME%TYPE;
37: L_DETAIL_LEVEL AR_LOOKUPS.MEANING%TYPE;
38: L_INCLUDE_TRX_TYPE VARCHAR2(1000);

Line 69: GL_SETS_OF_BOOKS GL,

65: SELECT
66: GL.SET_OF_BOOKS_ID
67: INTO L_SET_OF_BOOKS_ID
68: FROM
69: GL_SETS_OF_BOOKS GL,
70: AR_SYSTEM_PARAMETERS AR
71: WHERE GL.SET_OF_BOOKS_ID = AR.SET_OF_BOOKS_ID;
72: SELECT
73: GL.PERIOD_NAME

Line 149: GL_SETS_OF_BOOKS SOB

145: SELECT
146: SOB.NAME
147: INTO P_COMPANY_NAME_DESC
148: FROM
149: GL_SETS_OF_BOOKS SOB
150: WHERE SET_OF_BOOKS_ID = P_REP_CONTEXT_ENTITY_NAME;
151: ELSIF P_REP_CONTEXT_LVL_MNG = '2000' THEN
152: SELECT
153: LEDGER_NAME

Line 164: GL_SETS_OF_BOOKS SOB

160: SOB.NAME
161: INTO P_COMPANY_NAME_DESC
162: FROM
163: HR_OPERATING_UNITS HR,
164: GL_SETS_OF_BOOKS SOB
165: WHERE HR.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
166: AND HR.ORGANIZATION_ID = P_REP_CONTEXT_ENTITY_NAME;
167: END IF;
168: EXCEPTION