DBA Data[Home] [Help]

APPS.INV_INVPOPSR_XMLP_PKG dependencies on XLE_ASSOCIATIONS_V

Line 199: XLE_ASSOCIATIONS_V XAV

195: INTO L_DEF_TAX_REG_NO
196: FROM
197: ZX_PARTY_TAX_PROFILE ZPTP,
198: ZX_REGISTRATIONS ZR,
199: XLE_ASSOCIATIONS_V XAV
200: WHERE ZPTP.PARTY_TAX_PROFILE_ID = ZR.PARTY_TAX_PROFILE_ID
201: AND ZR.DEFAULT_REGISTRATION_FLAG = 'Y'
202: AND ZPTP.PARTY_ID = XAV.LEGAL_PARTY_ID
203: AND ZPTP.PARTY_TYPE_CODE = 'LEGAL_ESTABLISHMENT'