DBA Data[Home] [Help]

APPS.ZX_SBSCR_OPTIONS_MIGRATE_PKG dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 300: AR_SYSTEM_PARAMETERS_ALL ARSYS

296: SET ALLOW_EXEMPTIONS_FLAG = 'Y'
297: WHERE TAX_REGIME_ID IN (SELECT distinct RU.TAX_REGIME_ID
298: FROM ZX_REGIMES_USAGES RU,
299: ZX_PARTY_TAX_PROFILE PTP,
300: AR_SYSTEM_PARAMETERS_ALL ARSYS
301: WHERE PTP.PARTY_TAX_PROFILE_ID = RU.FIRST_PTY_ORG_ID
302: AND PTP.PARTY_TYPE_CODE = 'OU'
303: AND PTP.PARTY_ID = ARSYS.ORG_ID
304: AND nvl(ARSYS.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') = 'Y'

Line 313: AR_SYSTEM_PARAMETERS_ALL ARSYS

309: SET ALLOW_EXCEPTIONS_FLAG = 'Y'
310: WHERE TAX_REGIME_ID IN (SELECT TAX_REGIME_ID
311: FROM ZX_REGIMES_USAGES RU,
312: ZX_PARTY_TAX_PROFILE PTP,
313: AR_SYSTEM_PARAMETERS_ALL ARSYS
314: WHERE PTP.PARTY_TAX_PROFILE_ID = RU.FIRST_PTY_ORG_ID
315: AND PTP.PARTY_TYPE_CODE = 'OU'
316: AND PTP.PARTY_ID = ARSYS.ORG_ID
317: AND (nvl(ARSYS.TAX_USE_PRODUCT_EXEMPT_FLAG,'N') = 'Y'