APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on ZX_SERVICE_TYPES

Line 2425: FROM ZX_SERVICE_TYPES

2421:
2422: Begin
2423: SELECT context_flex_structure_id
2424: INTO l_context_flex_structure_id
2425: FROM ZX_SERVICE_TYPES
2426: WHERE service_category_code = 'USER_EXT'
2427: AND rownum=1;
2428: Exception when others then
2429: x_error_msg_tbl(l_error_counter) := 'No service type defined for user extension';

Line 2512: ZX_SERVICE_TYPES srvctypes

2508: fnd_global.conc_login_id --last_update_login;
2509: FROM ZX_REGIMES_USAGES ru,
2510: ZX_API_CODE_COMBINATIONS comb,
2511: ZX_SRVC_SUBSCRIPTIONS srvc,
2512: ZX_SERVICE_TYPES srvctypes
2513: WHERE ru.regime_usage_id = p_regime_usage_id
2514: AND srvc.srvc_provider_id = p_srvc_prvdr_id
2515: AND srvctypes.context_flex_structure_id= l_context_flex_structure_id
2516: AND srvc.regime_usage_id = ru.regime_usage_id

Line 2566: ZX_SERVICE_TYPES srvctypes

2562: l_context_cc_id
2563: FROM ZX_REGIMES_USAGES ru,
2564: ZX_API_CODE_COMBINATIONS comb,
2565: ZX_SRVC_SUBSCRIPTIONS srvc,
2566: ZX_SERVICE_TYPES srvctypes
2567: WHERE ru.regime_usage_id = p_regime_usage_id
2568: AND srvc.srvc_provider_id = p_srvc_prvdr_id
2569: AND srvctypes.context_flex_structure_id= l_context_flex_structure_id
2570: AND srvc.regime_usage_id = ru.regime_usage_id