515: SELECT DISTINCT(p.email_address)
516: FROM pa_object_dist_lists o,
517: pa_dist_list_items i,
518: pa_project_parties_v p, 519: fnd_user u 520: WHERE o.object_id = p_rp_id
521: AND o.list_id = i.list_id
522: AND i.recipient_type = 'PROJECT_ROLE'
523: AND p.project_role_id = i.recipient_id