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.CSTPPPSC dependencies on GL_PERIODS

Line 124: from gl_periods gp

120:
121:
122: CURSOR proper_period_to_open_cur IS
123: select end_date, period_name, period_year, period_num
124: from gl_periods gp
125: WHERE gp.ADJUSTMENT_PERIOD_FLAG = 'N'
126: and gp.period_set_name = open_period_set_name
127: and gp.end_date > last_scheduled_close_date
128: and gp.period_type = open_period_type

Line 131: from gl_periods gp1

127: and gp.end_date > last_scheduled_close_date
128: and gp.period_type = open_period_type
129: and gp.end_date = (
130: select min(gp1.end_date)
131: from gl_periods gp1
132: where gp1.ADJUSTMENT_PERIOD_FLAG = 'N'
133: and gp1.period_set_name = open_period_set_name
134: and gp1.period_type = open_period_type
135: and gp1.end_date > last_scheduled_close_date );

Line 496: /* 1. Insert into cst_pac_periods form gl_periods table */

492: AND PRIMARY_COST_METHOD > 2;
493:
494: /* **************************************************************************** */
495: /* START OPENING THE PERIOD. The steps are... */
496: /* 1. Insert into cst_pac_periods form gl_periods table */
497: /* 2. For each an every cost group defined in the legal entity */
498: /* Insert five rows for five process statuses into */
499: /* cst_pac_process_phases */
500: /* **************************************************************************** */

Line 543: FROM gl_periods gp

539: l_user_id,
540: SYSDATE,
541: l_user_id,
542: -1
543: FROM gl_periods gp
544: WHERE gp.period_name = open_period_name
545: AND gp.period_num = open_period_num
546: AND gp.period_year = open_period_year
547: AND gp.period_set_name = (select gsob.period_set_name