2158: if p_report_name = 'JEESAMOR' then -- Annual Report
2159:
2160: declare
2161:
2162: ld_start_date gl_periods.start_date%type;
2163: ld_end_date gl_periods.end_date%type;
2164: lv_tax_calendar jg_zz_vat_rep_entities.tax_calendar_name%type;
2165:
2166: /** Fetch the tax accounting calendar from Reporting Entity Setup */
2159:
2160: declare
2161:
2162: ld_start_date gl_periods.start_date%type;
2163: ld_end_date gl_periods.end_date%type;
2164: lv_tax_calendar jg_zz_vat_rep_entities.tax_calendar_name%type;
2165:
2166: /** Fetch the tax accounting calendar from Reporting Entity Setup */
2167: cursor c_get_tax_calendar
2175: */
2176: cursor c_get_start_end_dates
2177: is
2178: select min(start_date), max(end_date)
2179: from gl_periods
2180: where period_set_name = lv_tax_calendar
2181: and period_name in (P_FROM_PERIOD, P_TO_PERIOD);
2182:
2183: begin