DBA Data[Home] [Help]

APPS.JE_ES_MODELO_EXT_PKG dependencies on GL_PERIODS

Line 3764: ld_start_date gl_periods.start_date%type;

3760: if p_report_name = 'JEESAMOR' then -- Annual Report
3761:
3762: declare
3763:
3764: ld_start_date gl_periods.start_date%type;
3765: ld_end_date gl_periods.end_date%type;
3766: lv_tax_calendar jg_zz_vat_rep_entities.tax_calendar_name%type;
3767:
3768: /** Fetch the tax accounting calendar from Reporting Entity Setup */

Line 3765: ld_end_date gl_periods.end_date%type;

3761:
3762: declare
3763:
3764: ld_start_date gl_periods.start_date%type;
3765: ld_end_date gl_periods.end_date%type;
3766: lv_tax_calendar jg_zz_vat_rep_entities.tax_calendar_name%type;
3767:
3768: /** Fetch the tax accounting calendar from Reporting Entity Setup */
3769: cursor c_get_tax_calendar

Line 3781: from gl_periods

3777: */
3778: cursor c_get_start_end_dates
3779: is
3780: select min(start_date), max(end_date)
3781: from gl_periods
3782: where period_set_name = lv_tax_calendar
3783: and period_name in (P_FROM_PERIOD, P_TO_PERIOD);
3784:
3785: begin