DBA Data[Home] [Help]

APPS.JG_ZZ_VAT_YEARLY_EXT_PKG dependencies on GL_PERIODS

Line 57: FROM gl_periods glp

53:
54: CURSOR c_vat_act_period(lc_tax_cal_name IN VARCHAR2,lc_source IN VARCHAR2, ln_reporting_entity_id IN NUMBER,
55: ln_tax_cal_year IN NUMBER ) IS
56: SELECT glp.period_name period_name
57: FROM gl_periods glp
58: WHERE glp.period_year = ln_tax_cal_year
59: AND glp.period_set_name = lc_tax_cal_name
60: AND glp.period_name NOT IN
61: (SELECT jgvrs.tax_calendar_period period_name