eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_ZZ_COMMON_PKG dependencies on JG_ZZ_VAT_REP_STATUS

Line 95: ,jg_zz_vat_rep_status JZVRS

91: ,JZVTD.rep_context_entity_name
92: ,JZVTD.rep_entity_id
93: ,JZVTD.taxpayer_id
94: FROM jg_zz_vat_trx_details JZVTD
95: ,jg_zz_vat_rep_status JZVRS
96: ,jg_zz_vat_rep_entities JZVRE
97: ,gl_ledgers GL
98: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
99: AND JZVRS.vat_reporting_entity_id= pn_vat_rep_entity_id

Line 181: FROM jg_zz_vat_rep_status JZVRS

177: CURSOR lc_tax_registration IS
178: SELECT JZVRS.tax_registration_number
179: ,min(JZVRS.period_start_date)
180: ,max(JZVRS.period_end_date)
181: FROM jg_zz_vat_rep_status JZVRS
182: WHERE JZVRS.vat_reporting_entity_id= pn_vat_rep_entity_id
183: AND (JZVRS.tax_calendar_period = pv_period_name
184: OR JZVRS.tax_calendar_year = pn_period_year)
185: group by JZVRS.tax_registration_number;