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
3770: is
3768: /** Fetch the tax accounting calendar from Reporting Entity Setup */
3769: cursor c_get_tax_calendar
3770: is
3771: select tax_calendar_name
3772: from jg_zz_vat_rep_entities
3773: where vat_reporting_entity_id = p_vat_rep_entity_id;
3774:
3775: /**
3776: Derrive start date and end date using period range parameters P_FROM_PERIOD and P_TO_PERIOD