APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on ZX_REGIMES_USAGES

Line 2322: from zx_regimes_usages

2318: /*Fetch the parnter name*/
2319:
2320: select tax_regime_code
2321: into p_country_code
2322: from zx_regimes_usages
2323: where regime_usage_id=p_regime_usage_id;
2324:
2325: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2326: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' p_srvc_prvdr_id :'||p_srvc_prvdr_id);

Line 2454: l_tax_regime_code ZX_REGIMES_USAGES.tax_regime_code%type;

2450: l_context_flex_structure_id NUMBER;
2451: l_error_counter NUMBER;
2452:
2453: l_api_name varchar2(80) := 'CREATE_EXTN_REGISTN_FROM_UI';
2454: l_tax_regime_code ZX_REGIMES_USAGES.tax_regime_code%type;
2455: x_error_msg_tbl error_message_tbl%type;
2456: l_api_owner_id number;
2457: l_context_cc_id number;
2458:

Line 2484: FROM zx_regimes_usages ru,

2480:
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

Line 2555: FROM ZX_REGIMES_USAGES ru,

2551: fnd_global.user_Id, --created_by
2552: sysdate, --last_update_date
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

Line 2594: ZX_REGIMES_USAGES ru

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
2598: AND NOT EXISTS (SELECT 1

Line 2609: FROM ZX_REGIMES_USAGES ru,

2605: select ru.first_pty_org_id,
2606: comb.code_combination_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

Line 2728: zx_regimes_usages usage,

2724: Select
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'