DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_UTIL dependencies on ENG_SECURITY_GROUP_MEMBERS_V

Line 861: -- Replaced above sql to use ENG_SECURITY_GROUP_MEMBERS_V

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

Line 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

Line 1288: FROM ENG_SECURITY_GROUP_MEMBERS_V member

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