[Home] [Help]
144: Select per.period_set_name,
145: per.period_type,
146: min(start_date),
147: max(end_date)
148: From gl_periods per,
149: gl_sets_of_books book
150: where per.ADJUSTMENT_PERIOD_FLAG = 'N'
151: and per.period_set_name = book.period_set_name
152: and per.period_type = book.accounted_period_type
160: Select per.period_set_name,
161: per.period_type,
162: min(start_date),
163: max(end_date)
164: From gl_periods per,
165: gl_sets_of_books book
166: where
167: per.period_set_name = book.period_set_name
168: and per.period_type = book.accounted_period_type
183: from gl_date_period_map map,
184: pa_implementations_all imp,
185: gl_sets_of_books sob,
186: pa_periods_all paprd,
187: gl_periods glprd
188: where imp.set_of_books_id = sob.set_of_books_id
189: and paprd.org_id = imp.org_id
190: and map.period_type = imp.pa_period_type
191: and map.period_name = paprd.period_name
208: (glprd.period_year * 10000) + glprd.period_num
209: from pa_implementations_all imp,
210: gl_sets_of_books sob,
211: pa_periods_all paprd,
212: gl_periods glprd
213: where imp.set_of_books_id = sob.set_of_books_id
214: and paprd.org_id = imp.org_id
215: and paprd.end_date >= NVL(p_from_date, paprd.end_date)
216: and paprd.start_date <= NVL(p_to_date, paprd.start_date)
217: and paprd.period_name <> 'NOT ASSIGNED'
218: and paprd.period_name = glprd.period_name
219: and sob.period_set_name = glprd.period_set_name;
220:
221: /* Cursor to fetch GL periods */
222:
223: Cursor cal_period_cursor is
224: select distinct
225: per.period_set_name,
229: per.quarter_num,
230: per.start_date,
231: per.end_date,
232: (per.period_year * 10000) + per.period_num
233: from gl_periods per,
234: gl_sets_of_books book
235: where per.adjustment_period_flag = 'N'
236: and per.period_set_name = book.period_set_name
237: and per.period_type = book.accounted_period_type;
244: per.period_year,
245: per.quarter_num,
246: min(per.start_date),
247: max(per.end_date)
248: from gl_periods per,
249: gl_sets_of_books book
250: where per.period_set_name = book.period_set_name
251: and per.period_type = book.accounted_period_type
252: group by per.period_set_name,
261: period_type,
262: period_year,
263: min(start_date),
264: max(end_date)
265: from gl_periods per,
266: gl_sets_of_books book
267: where per.period_set_name = book.period_set_name
268: and per.period_type = book.accounted_period_type
269: group by per.period_set_name,
386: into l_period_name,
387: l_start_date,
388: l_end_date,
389: l_effective_period_num
390: from gl_periods
391: where period_set_name = l_period_set_name
392: and period_type = l_period_type
393: and start_date <= l_gl_date
394: and end_date >= l_gl_date
394: and end_date >= l_gl_date
395: and adjustment_period_flag = 'N';
396:
397: exception when no_data_found then
398: /* This can happen if there are gaps/holes in gl_periods */
399: l_period_name := 'NA_EDW';
400: end;
401:
402: end if;
1190: end_date,
1191: start_date,
1192: end_date-start_date+1,
1193: 'READY'
1194: FROM gl_periods
1195: where period_set_name = l_period_set_name
1196: and period_type = l_period_type
1197: and adjustment_period_flag='N';
1198:
1225: max(end_date), --END_DATE
1226: min(start_date), --START_DATE
1227: max(end_date)-min(start_date)+1, --TIMESPAN
1228: 'READY' --COLLECTION_STATUS
1229: FROM gl_periods
1230: where period_set_name=l_period_set_name
1231: and period_type = l_period_type
1232: and adjustment_period_flag='N'
1233: group by period_year, quarter_num;
1260: max(end_date), --END_DATE
1261: min(start_date), --START_DATE
1262: max(end_date)-min(start_date)+1, --TIMESPAN
1263: 'READY' --COLLECTION_STATUS
1264: FROM gl_periods
1265: where period_set_name=l_period_set_name
1266: and period_type = l_period_type
1267: and adjustment_period_flag='N'
1268: group by period_year;