APPS.ENG_WORKFLOW_UTIL dependencies on EGO_PEOPLE_V

Line 847: -- FROM EGO_PEOPLE_V member

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

Line 2014: -- Decide to use EGO_PEOPLE_V to prevent from future change

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

Line 2015: -- Sicne the EGO_PEOPLE_V may return multi recs per person id,

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

Line 2043: FROM EGO_PEOPLE_V

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

Line 3915: , EGO_PEOPLE_V EgoPeople

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: