APPS.PO_DATES_S dependencies on GL_PERIOD_STATUSES

Line 189: FROM gl_period_statuses ps

185: x_progress := '010';
186:
187: SELECT ps.closing_status
188: INTO x_closing_status
189: FROM gl_period_statuses ps
190: WHERE ps.application_id = x_app_id
191: AND ps.adjustment_period_flag = 'N'
192: AND ps.set_of_books_id = x_sob_id
193: AND trunc(x_trx_date) BETWEEN trunc(nvl(ps.start_date, x_trx_date))

Line 204: po_message_s.app_error(''); --bad data in gl_period_statuses

200: WHEN NO_DATA_FOUND then
201: po_message_s.app_error('PO_PO_ENTER_OPEN_GL_DATE');
202: RAISE;
203: WHEN TOO_MANY_ROWS then
204: po_message_s.app_error(''); --bad data in gl_period_statuses
205: RAISE;
206: WHEN OTHERS THEN
207: po_message_s.sql_error('get_closing_status', x_progress, sqlcode);
208: RAISE;

Line 238: gl_period_statuses glps,

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
242: AND oap.period_name = glp.period_name -- Bug 873654