DBA Data[Home] [Help]

APPS.FUN_TRX_PVT dependencies on FUN_SECURITY

Line 76: AND FUN_SECURITY.IS_ACCESS_VALID(HZP.PARTY_ID, HZP2.PARTY_ID) = 'Y' -- Access1

72: AND HZR.OBJECT_ID = p_party_id
73: AND HZC.PARTY_RELATIONSHIP_ID = HZR.RELATIONSHIP_ID
74: AND HZCR.ORG_CONTACT_ID = HZC.ORG_CONTACT_ID
75: AND HZCR.ROLE_TYPE = 'INTERCOMPANY_CONTACT_FOR'
76: AND FUN_SECURITY.IS_ACCESS_VALID(HZP.PARTY_ID, HZP2.PARTY_ID) = 'Y' -- Access1
77: AND DECODE(HZR.STATUS,'A','Y','I','N') = 'Y' -- status
78: AND HZR.ADDITIONAL_INFORMATION1 = 'Y' -- Notification
79: AND sysdate BETWEEN
80: nvl(HZR.start_date, sysdate -1)