DBA Data[Home] [Help]

APPS.INV_INVINPSR_XMLP_PKG dependencies on XLE_ASSOCIATIONS_V

Line 215: XLE_ASSOCIATIONS_V XAV

211: INTO L_DEF_TAX_REG_NO
212: FROM
213: ZX_PARTY_TAX_PROFILE ZPTP,
214: ZX_REGISTRATIONS ZR,
215: XLE_ASSOCIATIONS_V XAV
216: WHERE ZPTP.PARTY_TAX_PROFILE_ID = ZR.PARTY_TAX_PROFILE_ID
217: AND ZR.DEFAULT_REGISTRATION_FLAG = 'Y'
218: AND ZPTP.PARTY_ID = XAV.LEGAL_PARTY_ID
219: AND ZPTP.PARTY_TYPE_CODE = 'LEGAL_ESTABLISHMENT'