sub-query help needed

[sbcsandhu]

i have a report of different activities a person has done

i know that if a person has completed an acitivy they have a act_sts_cd of '04'

so basically if a person has a completed status, i want that, but if its not completed, then i want the max(bgn_dt)

im need it group by cs_id and sesn_id,
a person might have 2 or more sessions, so i want to see both of them.