APPS.ZX_ZXARRECV_XMLP_PKG dependencies on GL_PERIOD_STATUSES

Line 35: L_PERIOD_FROM APPS.GL_PERIOD_STATUSES.PERIOD_NAME%TYPE;

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);
39: BEGIN

Line 36: L_PERIOD_TO APPS.GL_PERIOD_STATUSES.PERIOD_NAME%TYPE;

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);
39: BEGIN
40: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

Line 76: GL_PERIOD_STATUSES GL,

72: SELECT
73: GL.PERIOD_NAME
74: INTO L_PERIOD_FROM
75: FROM
76: GL_PERIOD_STATUSES GL,
77: AR_SYSTEM_PARAMETERS AR
78: WHERE GL.START_DATE = P_GL_DATE_LOW
79: AND GL.SET_OF_BOOKS_ID = L_SET_OF_BOOKS_ID
80: AND GL.APPLICATION_ID = 222

Line 86: GL_PERIOD_STATUSES GL,

82: SELECT
83: GL.PERIOD_NAME
84: INTO L_PERIOD_TO
85: FROM
86: GL_PERIOD_STATUSES GL,
87: AR_SYSTEM_PARAMETERS AR
88: WHERE GL.END_DATE = P_GL_DATE_HIGH
89: AND GL.SET_OF_BOOKS_ID = L_SET_OF_BOOKS_ID
90: AND GL.APPLICATION_ID = 222