148: p_ou_id,
149: l_ledger_id,
150: -- WHO COLUMNS
151: sysdate,
152: FND_GLOBAL.user_id,
153: sysdate,
154: FND_GLOBAL.user_id,
155: FND_GLOBAL.login_id,
156: FND_GLOBAL.conc_request_id,
150: -- WHO COLUMNS
151: sysdate,
152: FND_GLOBAL.user_id,
153: sysdate,
154: FND_GLOBAL.user_id,
155: FND_GLOBAL.login_id,
156: FND_GLOBAL.conc_request_id,
157: FND_GLOBAL.PROG_APPL_ID,
158: FND_GLOBAL.CONC_PROGRAM_ID,
151: sysdate,
152: FND_GLOBAL.user_id,
153: sysdate,
154: FND_GLOBAL.user_id,
155: FND_GLOBAL.login_id,
156: FND_GLOBAL.conc_request_id,
157: FND_GLOBAL.PROG_APPL_ID,
158: FND_GLOBAL.CONC_PROGRAM_ID,
159: sysdate
152: FND_GLOBAL.user_id,
153: sysdate,
154: FND_GLOBAL.user_id,
155: FND_GLOBAL.login_id,
156: FND_GLOBAL.conc_request_id,
157: FND_GLOBAL.PROG_APPL_ID,
158: FND_GLOBAL.CONC_PROGRAM_ID,
159: sysdate
160: FROM gl_period_statuses gps
153: sysdate,
154: FND_GLOBAL.user_id,
155: FND_GLOBAL.login_id,
156: FND_GLOBAL.conc_request_id,
157: FND_GLOBAL.PROG_APPL_ID,
158: FND_GLOBAL.CONC_PROGRAM_ID,
159: sysdate
160: FROM gl_period_statuses gps
161: WHERE gps.application_id = 101 -- used GL instead of OM or AR in case they are not using GPS
154: FND_GLOBAL.user_id,
155: FND_GLOBAL.login_id,
156: FND_GLOBAL.conc_request_id,
157: FND_GLOBAL.PROG_APPL_ID,
158: FND_GLOBAL.CONC_PROGRAM_ID,
159: sysdate
160: FROM gl_period_statuses gps
161: WHERE gps.application_id = 101 -- used GL instead of OM or AR in case they are not using GPS
162: --BUG#7211401: Truncation of the event date for last date of the period