DBA Data[Home] [Help]

APPS.FUN_SECURITY dependencies on XLE_ENTITY_PROFILES

Line 91: XLE_ENTITY_PROFILES XFI,

87: IS
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