APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_SRVC_SUBSCRIPTIONS

Line 118: FROM zx_srvc_subscriptions srvc,

114: IF x_migrated_tax_regime_code IS NOT NULL AND x_migrated_tax_provider_id > 0 THEN
115: BEGIN
116: SELECT 1
117: INTO l_mig_exists
118: FROM zx_srvc_subscriptions srvc,
119: zx_regimes_usages usg
120: WHERE srvc.regime_usage_id = usg.regime_usage_id
121: AND l_mig_trx_date between srvc.effective_from and nvl(srvc.effective_to,l_mig_trx_date)
122: AND srvc.srvc_provider_id = x_migrated_tax_provider_id

Line 134: from zx_srvc_subscriptions srvc,

130: IF Nvl(l_mig_exists,0) = 0 AND l_mig_glb_att_cat IS NOT NULL THEN
131: BEGIN
132: SELECT usg.tax_regime_code
133: into x_migrated_tax_regime_code
134: from zx_srvc_subscriptions srvc,
135: zx_regimes_usages usg
136: where srvc.regime_usage_id = usg.regime_usage_id
137: and l_mig_trx_date between srvc.effective_from and nvl(srvc.effective_to,l_mig_trx_date)
138: and srvc.enabled_flag = 'Y'

Line 1276: -- based on the subscription setup from ZX_SRVC_SUBSCRIPTIONS table

1272: -- get_service_provider
1273: --
1274: -- DESCRIPTION
1275: -- This procedure returns the service provider for a given regime
1276: -- based on the subscription setup from ZX_SRVC_SUBSCRIPTIONS table
1277: --
1278: -- CALLED BY
1279: -- popl_pvrdr_info_tax_reg_tbl
1280: -- Tax forms

Line 1334: FROM ZX_SRVC_SUBSCRIPTIONS srvc,

1330: --Check the service provider to call for calculating tax
1331: BEGIN
1332: SELECT srvc.srvc_provider_id
1333: INTO x_provider_id
1334: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
1335: ZX_REGIMES_USAGES reg
1336: WHERE reg.tax_regime_code = p_tax_regime_code
1337: AND srvc.regime_usage_id = reg.regime_usage_id
1338: AND srvc.enabled_flag = 'Y'

Line 1406: -- ZX_SRVC_SUBSCRIPTIONS table. It is called from the import exemptions

1402: --
1403: -- DESCRIPTION
1404: -- This is an overloaded procedure which returns the service provider
1405: -- for a given regime based on the subscription setup from
1406: -- ZX_SRVC_SUBSCRIPTIONS table. It is called from the import exemptions
1407: -- which does not have information of the document
1408: --
1409: -- CALLED BY
1410: -- import_exemptions

Line 1435: FROM ZX_SRVC_SUBSCRIPTIONS srvc,

1431:
1432: --Check service provider to call for import exemptions
1433: SELECT srvc.srvc_provider_id
1434: INTO x_provider_id
1435: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
1436: ZX_REGIMES_USAGES reg
1437: WHERE reg.tax_regime_code = p_tax_regime_code
1438: AND srvc.regime_usage_id = reg.regime_usage_id
1439: AND srvc.enabled_flag = 'Y'