Line 94: AND FUN_TCA_PKG.GET_LE_ID(HZP.PARTY_ID)=XFI.PARTY_ID
90: FROM HZ_PARTIES HZP,
91: XLE_ENTITY_PROFILES XFI,
92: HZ_PARTY_USG_ASSIGNMENTS HUA
93: WHERE HZP.PARTY_TYPE='ORGANIZATION' 94: AND FUN_TCA_PKG.GET_LE_ID(HZP.PARTY_ID)=XFI.PARTY_ID 95: AND HUA.PARTY_ID=HZP.PARTY_ID
96: AND HUA.PARTY_USAGE_CODE ='INTERCOMPANY_ORG'
97: AND XFI.TRANSACTING_ENTITY_FLAG = 'Y') QRSLT
98: WHERE (PARTYID not in ( select object_id