[Home] [Help]
2481: Begin
2482: SELECT distinct ru.tax_regime_code
2483: into l_tax_regime_code
2484: FROM zx_regimes_usages ru,
2485: zx_srvc_subscriptions srvc
2486: WHERE srvc.regime_usage_id=p_regime_usage_id
2487: and srvc.regime_usage_id=ru.regime_usage_id
2488: AND NOT EXISTS (SELECT 1
2489: FROM ZX_API_CODE_COMBINATIONS comb
2553: fnd_global.user_id, --last_updated_by
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
2589: fnd_global.user_Id, --created_by
2590: sysdate, --last_update_date
2591: fnd_global.user_id, --last_updated_by
2592: fnd_global.conc_login_id --last_update_login;
2593: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
2594: ZX_REGIMES_USAGES ru
2595: WHERE ru.regime_usage_id = p_regime_usage_id
2596: AND srvc.srvc_provider_id = p_srvc_prvdr_id
2597: AND srvc.regime_usage_id = ru.regime_usage_id
2607: INTO l_api_owner_id,
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
2725: distinct srvc.srvc_provider_id
2726: into l_srvc_provider_id
2727: from zx_api_code_combinations comb,
2728: zx_regimes_usages usage,
2729: zx_srvc_subscriptions srvc
2730: where comb.code_combination_id= p_context_cc_id
2731: and comb.segment_attribute1= usage.tax_regime_code
2732: and comb.segment_attribute2= 'O2C'
2733: and usage.first_pty_org_id= p_api_owner_id