APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on ZX_SERVICE_TYPES

Line 2470: FROM ZX_SERVICE_TYPES

2466:
2467: Begin
2468: SELECT context_flex_structure_id
2469: INTO l_context_flex_structure_id
2470: FROM ZX_SERVICE_TYPES
2471: WHERE service_category_code = 'USER_EXT'
2472: AND rownum=1;
2473: Exception when others then
2474: x_error_msg_tbl(l_error_counter) := 'No service type defined for user extension';

Line 2558: ZX_SERVICE_TYPES srvctypes

2554: fnd_global.conc_login_id --last_update_login;
2555: FROM ZX_REGIMES_USAGES ru,
2556: ZX_API_CODE_COMBINATIONS comb,
2557: ZX_SRVC_SUBSCRIPTIONS srvc,
2558: ZX_SERVICE_TYPES srvctypes
2559: WHERE ru.regime_usage_id = p_regime_usage_id
2560: AND srvc.srvc_provider_id = p_srvc_prvdr_id
2561: AND srvctypes.context_flex_structure_id= l_context_flex_structure_id
2562: AND srvc.regime_usage_id = ru.regime_usage_id

Line 2612: ZX_SERVICE_TYPES srvctypes

2608: l_context_cc_id
2609: FROM ZX_REGIMES_USAGES ru,
2610: ZX_API_CODE_COMBINATIONS comb,
2611: ZX_SRVC_SUBSCRIPTIONS srvc,
2612: ZX_SERVICE_TYPES srvctypes
2613: WHERE ru.regime_usage_id = p_regime_usage_id
2614: AND srvc.srvc_provider_id = p_srvc_prvdr_id
2615: AND srvctypes.context_flex_structure_id= l_context_flex_structure_id
2616: AND srvc.regime_usage_id = ru.regime_usage_id