155: BEGIN
156: --Looking for a grant from PA for the party being merged
157: SELECT 1
158: INTO l_dummy 159: FROM fnd_grants g, fnd_objects o 160: WHERE o.application_id = 275
161: AND g.object_id = o.object_id
162: AND g.grantee_type = 'USER'
163: AND g.grantee_key = 'HZ_PARTY:'||p_from_fk_id