DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_GRP dependencies on GL_PERIOD_STATUSES

Line 160: FROM gl_period_statuses gps

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
163: AND TRUNC(p_event_date) BETWEEN gps.start_date AND gps.end_date
164: AND gps.set_of_books_id = l_ledger_id;

Line 347: gl_period_statuses gps,

343: l_stmt_num := 10;
344: SELECT count(*)
345: INTO l_closed_cst_periods
346: FROM org_acct_periods oap,
347: gl_period_statuses gps,
348: hr_organization_information hoi
349: WHERE oap.organization_id = hoi.organization_id
350: AND oap.period_name = gps.period_name
351: AND oap.open_flag = 'N'