843: --
844: -- CURSOR c_grp_members (p_group_id NUMBER)
845: -- IS
846: -- SELECT member.user_name user_role
847: -- FROM EGO_PEOPLE_V member
848: -- , HZ_RELATIONSHIPS member_group
849: -- , HZ_PARTIES grp
850: -- WHERE member_group.object_id = grp.party_id
851: -- AND member_group.subject_id = member.person_id
2010:
2011: begin
2012:
2013: /* Comment out for bug3038792
2014: -- Decide to use EGO_PEOPLE_V to prevent from future change
2015: -- Sicne the EGO_PEOPLE_V may return multi recs per person id,
2016: -- we just pick first fetched rec
2017: SELECT employee.party_name party_name
2018: , company.party_name comp_name
2011: begin
2012:
2013: /* Comment out for bug3038792
2014: -- Decide to use EGO_PEOPLE_V to prevent from future change
2015: -- Sicne the EGO_PEOPLE_V may return multi recs per person id,
2016: -- we just pick first fetched rec
2017: SELECT employee.party_name party_name
2018: , company.party_name comp_name
2019: INTO x_party_name
2039: SELECT person_name party_name
2040: , company_name comp_name
2041: INTO x_party_name
2042: , x_party_company
2043: FROM EGO_PEOPLE_V
2044: WHERE person_id = p_party_id
2045: AND ROWNUM = 1 ;
2046:
2047: exception
3911: , ecav.description description
3912: , EgoPeople.person_name person_name
3913: , EgoPeople.company_name company_name
3914: FROM ENG_CHANGE_ACTIONS_VL ecav
3915: , EGO_PEOPLE_V EgoPeople
3916: WHERE EgoPeople.user_id = ecav.created_by
3917: AND ecav.action_id = p_action_id ;
3918:
3919: