APPS.JG_ZZ_VAT_YEARLY_EXT_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 46: FROM jg_zz_vat_rep_entities jgvre

42: FUNCTION beforeReport RETURN BOOLEAN IS
43:
44: CURSOR c_vat_period(ln_reporting_entity_id IN NUMBER, ln_tax_cal_year IN NUMBER) IS
45: SELECT DISTINCT jgvrs.source source
46: FROM jg_zz_vat_rep_entities jgvre
47: ,jg_zz_vat_rep_status jgvrs
48: WHERE jgvrs.vat_reporting_entity_id = jgvre.vat_reporting_entity_id
49: AND jgvre.vat_reporting_entity_id = ln_reporting_entity_id
50: AND jgvrs.final_reporting_status_flag = 'S'

Line 62: FROM jg_zz_vat_rep_entities jgvre,

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
62: FROM jg_zz_vat_rep_entities jgvre,
63: jg_zz_vat_rep_status jgvrs
64: WHERE jgvrs.vat_reporting_entity_id = jgvre.vat_reporting_entity_id
65: AND jgvre.vat_reporting_entity_id = ln_reporting_entity_id
66: AND jgvrs.final_reporting_status_flag = 'S'