DBA Data[Home] [Help]

APPS.JE_JEDEAPVR_XMLP_PKG dependencies on GL_PERIOD_STATUSES

Line 92: GL_PERIOD_STATUSES

88: SELECT
89: ( PERIOD_YEAR * 10000 ) + PERIOD_NUM
90: INTO P_PERIOD_NUM_FROM
91: FROM
92: GL_PERIOD_STATUSES
93: WHERE PERIOD_NAME = P_PERIOD_FROM
94: AND SET_OF_BOOKS_ID = T_SET_OF_BOOKS_ID
95: AND APPLICATION_ID = T_APP_ID;
96: /*SRW.MESSAGE('999'

Line 102: GL_PERIOD_STATUSES

98: SELECT
99: ( PERIOD_YEAR * 10000 ) + PERIOD_NUM
100: INTO P_PERIOD_NUM_TO
101: FROM
102: GL_PERIOD_STATUSES
103: WHERE PERIOD_NAME = P_PERIOD_TO
104: AND SET_OF_BOOKS_ID = T_SET_OF_BOOKS_ID
105: AND APPLICATION_ID = T_APP_ID;
106: IF P_BALANCING_SEGMENT IS NOT NULL THEN

Line 202: GL_PERIOD_STATUSES

198: START_DATE,
199: END_DATE
200: INTO TSTART_DATE,TEND_DATE
201: FROM
202: GL_PERIOD_STATUSES
203: WHERE PERIOD_NAME = TPERIOD_NAME
204: AND SET_OF_BOOKS_ID = TSET_OF_BOOKS_ID
205: AND APPLICATION_ID = APP_ID;
206: EXCEPTION