APPS.EGO_PARTY_PUB dependencies on EGO_PEOPLE_V

Line 2110: EGO_PEOPLE_V member

2106:
2107: CURSOR c_grp_member_emailaddr (cp_group_id IN NUMBER) IS
2108: SELECT member.email_address
2109: FROM hz_relationships grp_rel,
2110: EGO_PEOPLE_V member
2111: WHERE grp_rel.object_id = cp_group_id
2112: AND grp_rel.object_type = 'GROUP'
2113: AND grp_rel.relationship_type = 'MEMBERSHIP'
2114: AND grp_rel.status = 'A'

Line 2167: FROM ego_people_v

2163: IF (l_party_type = 'PERSON') THEN
2164:
2165: SELECT email_address
2166: INTO l_concat_email_addresses
2167: FROM ego_people_v
2168: WHERE person_id = p_party_id;
2169: mdebug('GET_EMAIL_ADDRESSES: person email address is ' || l_concat_email_addresses);
2170:
2171: ELSIF (l_party_type = 'GROUP') THEN