192: ZR.REGISTRATION_NUMBER
193: INTO L_DEF_TAX_REG_NO
194: FROM
195: ZX_PARTY_TAX_PROFILE ZPTP,
196: ZX_REGISTRATIONS ZR,
197: XLE_ASSOCIATIONS_V XAV
198: WHERE ZPTP.PARTY_TAX_PROFILE_ID = ZR.PARTY_TAX_PROFILE_ID
199: AND ZR.DEFAULT_REGISTRATION_FLAG = 'Y'
200: AND ZPTP.PARTY_ID = XAV.LEGAL_PARTY_ID
209: INTO L_DEF_TAX_REG_NO
210: FROM
211: XLE_ETB_PROFILES XEP,
212: ZX_PARTY_TAX_PROFILE ZPTP,
213: ZX_REGISTRATIONS ZR,
214: ORG_ORGANIZATION_DEFINITIONS OOD
215: WHERE ZPTP.PARTY_TAX_PROFILE_ID = ZR.PARTY_TAX_PROFILE_ID
216: AND ZR.DEFAULT_REGISTRATION_FLAG = 'Y'
217: AND ZPTP.PARTY_ID = XEP.PARTY_ID