APPS.JG_ZZ_VAT_YEARLY_EXT_PKG dependencies on JG_ZZ_VAT_REP_STATUS

Line 47: ,jg_zz_vat_rep_status jgvrs

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'
51: AND jgvrs.tax_calendar_year = ln_tax_cal_year

Line 63: jg_zz_vat_rep_status jgvrs

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'
67: AND jgvrs.source = lc_source

Line 73: FROM jg_zz_vat_rep_status jgvrs

69: ORDER BY glp.period_name;
70:
71: CURSOR c_tax_calendar_name IS
72: SELECT DISTINCT jgvrs.tax_calendar_name
73: FROM jg_zz_vat_rep_status jgvrs
74: WHERE jgvrs.vat_reporting_entity_id = p_reporting_entity_id
75: AND jgvrs.tax_calendar_year = p_tax_calendar_year;
76:
77: lc_final_not_run VARCHAR2(150);