168: BEGIN
169: --Looking for a grant from PA for the party being merged
170: SELECT 1
171: INTO l_dummy 172: FROM fnd_grants g, fnd_objects o 173: WHERE o.application_id = 275
174: AND g.object_id = o.object_id
175: AND g.grantee_type = 'USER'
176: AND g.grantee_key = 'HZ_PARTY:'||p_from_fk_id