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.ZX_TPI_SERVICES_PKG dependencies on ZX_REGIMES_USAGES

Line 119: zx_regimes_usages usg

115: BEGIN
116: SELECT 1
117: INTO l_mig_exists
118: FROM zx_srvc_subscriptions srvc,
119: zx_regimes_usages usg
120: WHERE srvc.regime_usage_id = usg.regime_usage_id
121: AND l_mig_trx_date between srvc.effective_from and nvl(srvc.effective_to,l_mig_trx_date)
122: AND srvc.srvc_provider_id = x_migrated_tax_provider_id
123: AND usg.first_pty_org_id = l_mig_first_pty_id

Line 135: zx_regimes_usages usg

131: BEGIN
132: SELECT usg.tax_regime_code
133: into x_migrated_tax_regime_code
134: from zx_srvc_subscriptions srvc,
135: zx_regimes_usages usg
136: where srvc.regime_usage_id = usg.regime_usage_id
137: and l_mig_trx_date between srvc.effective_from and nvl(srvc.effective_to,l_mig_trx_date)
138: and srvc.enabled_flag = 'Y'
139: and srvc_provider_id = x_migrated_tax_provider_id

Line 1335: ZX_REGIMES_USAGES reg

1331: BEGIN
1332: SELECT srvc.srvc_provider_id
1333: INTO x_provider_id
1334: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
1335: ZX_REGIMES_USAGES reg
1336: WHERE reg.tax_regime_code = p_tax_regime_code
1337: AND srvc.regime_usage_id = reg.regime_usage_id
1338: AND srvc.enabled_flag = 'Y'
1339: AND srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW

Line 1436: ZX_REGIMES_USAGES reg

1432: --Check service provider to call for import exemptions
1433: SELECT srvc.srvc_provider_id
1434: INTO x_provider_id
1435: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
1436: ZX_REGIMES_USAGES reg
1437: WHERE reg.tax_regime_code = p_tax_regime_code
1438: AND srvc.regime_usage_id = reg.regime_usage_id
1439: AND srvc.enabled_flag = 'Y'
1440: AND (ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW is null OR