APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on ZX_REGIMES_USAGES

Line 2277: from zx_regimes_usages

2273: /*Fetch the parnter name*/
2274:
2275: select tax_regime_code
2276: into p_country_code
2277: from zx_regimes_usages
2278: where regime_usage_id=p_regime_usage_id;
2279:
2280: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2281: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' p_srvc_prvdr_id :'||p_srvc_prvdr_id);

Line 2409: l_tax_regime_code ZX_REGIMES_USAGES.tax_regime_code%type;

2405: l_context_flex_structure_id NUMBER;
2406: l_error_counter NUMBER;
2407:
2408: l_api_name varchar2(80) := 'CREATE_EXTN_REGISTN_FROM_UI';
2409: l_tax_regime_code ZX_REGIMES_USAGES.tax_regime_code%type;
2410: x_error_msg_tbl error_message_tbl%type;
2411: l_api_owner_id number;
2412: l_context_cc_id number;
2413:

Line 2439: FROM zx_regimes_usages ru,

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

Line 2509: FROM ZX_REGIMES_USAGES ru,

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

Line 2548: ZX_REGIMES_USAGES ru

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

Line 2563: FROM ZX_REGIMES_USAGES ru,

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

Line 2681: zx_regimes_usages usage,

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