eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on GL_PERIODS

Line 410: -- that is in GL_PERIODS but not open (i.e. not in ORG_ACCT_PERIODS)

406: FROM org_acct_periods
407: WHERE organization_id = p_org_id;
408:
409: -- Check that there is no period prior to one we are trying to open
410: -- that is in GL_PERIODS but not open (i.e. not in ORG_ACCT_PERIODS)
411: -- A status of %NOTFOUND indicates it is okay to open the next period.
412: CURSOR check_prior_open_period IS
413: SELECT start_date
414: FROM gl_periods

Line 414: FROM gl_periods

410: -- that is in GL_PERIODS but not open (i.e. not in ORG_ACCT_PERIODS)
411: -- A status of %NOTFOUND indicates it is okay to open the next period.
412: CURSOR check_prior_open_period IS
413: SELECT start_date
414: FROM gl_periods
415: WHERE end_date < p_period_end_date
416: AND end_date >= x_last_scheduled_close_date
417: AND (period_name, period_year) not in
418: (select period_name, period_year

Line 607: FROM gl_periods GLP

603:
604: GLP.end_date, -- schedule_close_date
605: 'Y', -- open_flag
606: -1 -- last_update_login
607: FROM gl_periods GLP
608: WHERE GLP.period_set_name = p_org_period_set_name
609: AND GLP.period_name = p_open_period_name
610: AND GLP.period_type = p_acct_period_type
611: AND GLP.adjustment_period_flag = 'N'