APPS.ZX_SBSCR_OPTIONS_MIGRATE_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 55: ZX_PARTY_TAX_PROFILE ptp,

51: SYSDATE ,
52: fnd_global.user_id ,
53: fnd_global.conc_login_id
54: FROM ZX_REGIMES_B regime,
55: ZX_PARTY_TAX_PROFILE ptp,
56: ( SELECT decode(l_multi_org_flag,'N',l_org_id,org_id) org_id
57: FROM ap_tax_codes_all
58: UNION
59: SELECT decode(l_multi_org_flag,'N',l_org_id,org_id) org_id

Line 299: ZX_PARTY_TAX_PROFILE PTP,

295: UPDATE ZX_REGIMES_B
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

Line 312: ZX_PARTY_TAX_PROFILE PTP,

308: UPDATE ZX_REGIMES_B
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