857: -- AND (member_group.end_date IS NULL OR member_group.end_date >= SYSDATE)
858: -- AND grp.party_id = p_group_id ;
859: --
860:
861: -- Replaced above sql to use ENG_SECURITY_GROUP_MEMBERS_V
862: CURSOR c_grp_members (p_group_id NUMBER)
863: IS
864: SELECT member.member_user_name user_role
865: FROM ENG_SECURITY_GROUP_MEMBERS_V member
861: -- Replaced above sql to use ENG_SECURITY_GROUP_MEMBERS_V
862: CURSOR c_grp_members (p_group_id NUMBER)
863: IS
864: SELECT member.member_user_name user_role
865: FROM ENG_SECURITY_GROUP_MEMBERS_V member
866: WHERE member.group_id = p_group_id ;
867:
868:
869: BEGIN
1284: IS
1285: CURSOR c_grp_members (p_group_id NUMBER)
1286: IS
1287: SELECT member.member_user_name user_role
1288: FROM ENG_SECURITY_GROUP_MEMBERS_V member
1289: WHERE member.group_id = p_group_id ;
1290:
1291:
1292: BEGIN