DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_REGIMES_USAGES

Line 1211: ZX_REGIMES_USAGES reg

1207: BEGIN
1208: SELECT srvc.srvc_provider_id
1209: INTO x_provider_id
1210: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
1211: ZX_REGIMES_USAGES reg
1212: WHERE reg.tax_regime_code = p_tax_regime_code
1213: AND srvc.regime_usage_id = reg.regime_usage_id
1214: AND srvc.enabled_flag = 'Y'
1215: AND srvc.prod_family_grp_code = ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW

Line 1307: ZX_REGIMES_USAGES reg

1303: --Check service provider to call for import exemptions
1304: SELECT srvc.srvc_provider_id
1305: INTO x_provider_id
1306: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
1307: ZX_REGIMES_USAGES reg
1308: WHERE reg.tax_regime_code = p_tax_regime_code
1309: AND srvc.regime_usage_id = reg.regime_usage_id
1310: AND srvc.enabled_flag = 'Y'
1311: AND (ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW is null OR