DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_SRVC_SUBSCRIPTIONS

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

1153: -- get_service_provider
1154: --
1155: -- DESCRIPTION
1156: -- This procedure returns the service provider for a given regime
1157: -- based on the subscription setup from ZX_SRVC_SUBSCRIPTIONS table
1158: --
1159: -- CALLED BY
1160: -- popl_pvrdr_info_tax_reg_tbl
1161: -- Tax forms

Line 1210: FROM ZX_SRVC_SUBSCRIPTIONS srvc,

1206: --Check the service provider to call for calculating tax
1207: BEGIN
1208: SELECT srvc.srvc_provider_id
1209: INTO x_provider_id
1210: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
1211: ZX_REGIMES_USAGES reg
1212: WHERE reg.tax_regime_code = p_tax_regime_code
1213: AND srvc.regime_usage_id = reg.regime_usage_id
1214: AND srvc.enabled_flag = 'Y'

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

1273: --
1274: -- DESCRIPTION
1275: -- This is an overloaded procedure which returns the service provider
1276: -- for a given regime based on the subscription setup from
1277: -- ZX_SRVC_SUBSCRIPTIONS table. It is called from the import exemptions
1278: -- which does not have information of the document
1279: --
1280: -- CALLED BY
1281: -- import_exemptions

Line 1306: FROM ZX_SRVC_SUBSCRIPTIONS srvc,

1302:
1303: --Check service provider to call for import exemptions
1304: SELECT srvc.srvc_provider_id
1305: INTO x_provider_id
1306: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
1307: ZX_REGIMES_USAGES reg
1308: WHERE reg.tax_regime_code = p_tax_regime_code
1309: AND srvc.regime_usage_id = reg.regime_usage_id
1310: AND srvc.enabled_flag = 'Y'