[Home] [Help]
2436: Begin
2437: SELECT distinct ru.tax_regime_code
2438: into l_tax_regime_code
2439: FROM zx_regimes_usages ru,
2440: zx_srvc_subscriptions srvc
2441: WHERE srvc.regime_usage_id=p_regime_usage_id
2442: and srvc.regime_usage_id=ru.regime_usage_id
2443: AND NOT EXISTS (SELECT 1
2444: FROM ZX_API_CODE_COMBINATIONS comb
2507: fnd_global.user_id, --last_updated_by
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
2543: fnd_global.user_Id, --created_by
2544: sysdate, --last_update_date
2545: fnd_global.user_id, --last_updated_by
2546: fnd_global.conc_login_id --last_update_login;
2547: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
2548: ZX_REGIMES_USAGES ru
2549: WHERE ru.regime_usage_id = p_regime_usage_id
2550: AND srvc.srvc_provider_id = p_srvc_prvdr_id
2551: AND srvc.regime_usage_id = ru.regime_usage_id
2561: INTO l_api_owner_id,
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
2678: distinct srvc.srvc_provider_id
2679: into l_srvc_provider_id
2680: from zx_api_code_combinations comb,
2681: zx_regimes_usages usage,
2682: zx_srvc_subscriptions srvc
2683: where comb.code_combination_id= p_context_cc_id
2684: and comb.segment_attribute1= usage.tax_regime_code
2685: and comb.segment_attribute2= 'O2C'
2686: and usage.first_pty_org_id= p_api_owner_id