26: and sysdate >= start_date and sysdate < end_date
27: start with parameter = to_char(p_grp_id)
28: connect by prior to_char(approval_group_id) = parameter
29: union 30: select to_number(p_grp_id) from dual; 31: --
32: -- given a group_id, this will find all members including the members within the nested groups too.
33: --
34: cursor c_expanded_nested_grps(p_grp_id number) is