DBA Data[Home] [Help]

APPS.FUN_SECURITY dependencies on FUN_TCA_PKG

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