[Home] [Help]
149:
150:
151: CURSOR proper_period_to_open_cur IS
152: select end_date, period_name, period_year, period_num
153: from gl_periods gp
154: WHERE gp.ADJUSTMENT_PERIOD_FLAG = 'N'
155: and gp.period_set_name = open_period_set_name
156: and gp.end_date > last_scheduled_close_date
157: and gp.period_type = open_period_type
156: and gp.end_date > last_scheduled_close_date
157: and gp.period_type = open_period_type
158: and gp.end_date = (
159: select min(gp1.end_date)
160: from gl_periods gp1
161: where gp1.ADJUSTMENT_PERIOD_FLAG = 'N'
162: and gp1.period_set_name = open_period_set_name
163: and gp1.period_type = open_period_type
164: and gp1.end_date > last_scheduled_close_date );
521: AND PRIMARY_COST_METHOD > 2;
522:
523: /* **************************************************************************** */
524: /* START OPENING THE PERIOD. The steps are... */
525: /* 1. Insert into cst_pac_periods form gl_periods table */
526: /* 2. For each an every cost group defined in the legal entity */
527: /* Insert five rows for five process statuses into */
528: /* cst_pac_process_phases */
529: /* **************************************************************************** */
568: l_user_id,
569: SYSDATE,
570: l_user_id,
571: -1
572: FROM gl_periods gp
573: WHERE gp.period_name = open_period_name
574: AND gp.period_num = open_period_num
575: AND gp.period_year = open_period_year
576: AND gp.period_set_name = (select gsob.period_set_name