DBA Data[Home] [Help]

APPS.FUN_SECURITY dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 92: HZ_PARTY_USG_ASSIGNMENTS HUA

88: select * from (SELECT hzp.party_id AS partyid,
89: DECODE(xfi.party_id,NULL,'REMOTE','LOCAL') AS local
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'