[Home] [Help]
428: ,x_fiscal_year
429: ,x_quarter_num
430: ,x_period_num
431: FROM gl_period_statuses gps
432: ,pa_implementations pi
433: WHERE gps.period_name = p_gl_period
434: AND gps.application_id = g_gl_app_id
435: AND gps.set_of_books_id = pi.set_of_books_id;
436:
466: ,gps.period_num
467: INTO x_fiscal_year
468: ,x_period_num
469: FROM gl_period_statuses gps
470: ,pa_implementations pi
471: WHERE gps.application_id = g_gl_app_id
472: AND gps.set_of_books_id = pi.set_of_books_id
473: AND gps.adjustment_period_flag = 'N'
474: AND gps.start_date =
473: AND gps.adjustment_period_flag = 'N'
474: AND gps.start_date =
475: (SELECT MIN(gps.start_date)
476: FROM gl_period_statuses gps
477: ,pa_implementations pi
478: WHERE gps.application_id = g_gl_app_id
479: AND gps.set_of_books_id = pi.set_of_books_id
480: AND gps.adjustment_period_flag = 'N'
481: AND gps.start_date >
480: AND gps.adjustment_period_flag = 'N'
481: AND gps.start_date >
482: (SELECT gps.end_date
483: FROM gl_period_statuses gps
484: ,pa_implementations pi
485: WHERE gps.application_id = g_gl_app_id
486: AND gps.set_of_books_id = pi.set_of_books_id
487: AND gps.period_year = p_fiscal_year
488: AND gps.period_num = p_period_num));
517: -- Test if the cdl row has already been placed in service
518: SELECT COUNT(*)
519: INTO ln_count
520: FROM gl_period_statuses gps
521: ,pa_implementations pi
522: WHERE gps.period_year = p_fiscal_year
523: AND gps.application_id = g_gl_app_id
524: AND gps.set_of_books_id = pi.set_of_books_id
525: AND adjustment_period_flag = 'N';
1291:
1292:
1293: -- Working storage variables
1294:
1295: ln_org_id pa_implementations_all.org_id%TYPE;
1296: lv_currency_code gl_sets_of_books.currency_code%TYPE;
1297:
1298: ld_period_start_date gl_period_statuses.start_date%TYPE;
1299: