DBA Data[Home] [Help]

APPS.PO_DATES_S dependencies on ORG_ACCT_PERIODS

Line 237: FROM org_acct_periods oap,

233: x_progress := '010';
234:
235: /* SELECT glps.closing_status
236: INTO x_closing_status
237: FROM org_acct_periods oap,
238: gl_period_statuses glps,
239: gl_periods glp
240: WHERE oap.organization_id = x_org_id
241: AND oap.period_set_name = glp.period_set_name

Line 256: FROM org_acct_periods oap

252: AND glps.adjustment_period_flag = 'N';
253: */
254: SELECT oap.open_flag
255: INTO x_open_flag
256: FROM org_acct_periods oap
257: WHERE oap.organization_id = x_org_id
258: AND (trunc(x_trx_date)
259: BETWEEN trunc(oap.period_start_date) AND
260: trunc(nvl(oap.period_close_date, oap.schedule_close_date)))