DBA Data[Home] [Help]

APPS.EGO_GROUP_WF_PKG dependencies on EGO_GROUP_MEMBERS_V

Line 1375: FROM EGO_GROUP_MEMBERS_V

1371:
1372: CURSOR c_get_member(cp_group_id NUMBER
1373: ,cp_member_id NUMBER) IS
1374: SELECT 'Y'
1375: FROM EGO_GROUP_MEMBERS_V
1376: WHERE group_id = cp_group_id
1377: AND member_person_id = cp_member_id;
1378:
1379: l_already_member VARCHAR2(1):='N';

Line 1660: FROM ego_group_members_v

1656: ----------------------------------------------------------------------
1657:
1658: CURSOR c_get_member_party_names (cp_group_id IN NUMBER) IS
1659: SELECT member_user_name, member_person_name, member_person_id
1660: FROM ego_group_members_v
1661: WHERE group_id = cp_group_id;
1662:
1663: l_group_id NUMBER;
1664: l_group_name HZ_PARTIES.PARTY_NAME%TYPE;