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_SUMMARY_ALL_PKG dependencies on JE_IL_VAT_LIMITS

Line 185: JE_IL_VAT_LIMITS JLMT,

181: IS
182: SELECT
183: JLMT.VAT_AGGREGATE_LIMIT_AMT
184: FROM
185: JE_IL_VAT_LIMITS JLMT,
186: JG_ZZ_VAT_REP_STATUS JZVRS
187: WHERE
188: JZVRS.VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID
189: AND JZVRS.TAX_CALENDAR_PERIOD = P_PERIOD

Line 2191: JE_IL_VAT_LIMITS JLMT,

2187: JLMT.PERIOD_YEAR || DECODE(LENGTH(JLMT.PERIOD_NUM), 1, 0 || JLMT.PERIOD_NUM, JLMT.PERIOD_NUM) TAX_PERIOD,
2188: TO_CHAR(sta.period_end_date,'RRRRMMDD') LAST_DAY_TAX_PERIOD
2189: INTO var_system_date, var_tax_period, var_last_day_tax_period
2190: FROM
2191: JE_IL_VAT_LIMITS JLMT,
2192: JG_ZZ_VAT_REP_STATUS STA
2193: WHERE
2194: STA.VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID
2195: AND STA.TAX_CALENDAR_PERIOD = p_period