DBA Data[Home] [Help]

APPS.ZX_ZXARRECV_XMLP_PKG dependencies on AR_SYSTEM_PARAMETERS

Line 70: AR_SYSTEM_PARAMETERS AR

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
74: INTO L_PERIOD_FROM

Line 77: AR_SYSTEM_PARAMETERS AR

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
81: AND ROWNUM = 1;

Line 87: AR_SYSTEM_PARAMETERS AR

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
91: AND ROWNUM = 1;