APPS.MSC_GET_NAME dependencies on MSC_SRP_USER_GROUPS

Line 5711: msc_srp_user_groups owner,

5707: cursor group_by_owner(c_owner varchar2, c_planner varchar2) is
5708: select
5709: g.group_name
5710: from
5711: msc_srp_user_groups owner,
5712: msc_srp_groups g
5713: where
5714: owner.user_id = c_owner
5715: and owner.group_id=g.group_id

Line 5717: ( select 1 from msc_srp_user_groups planner

5713: where
5714: owner.user_id = c_owner
5715: and owner.group_id=g.group_id
5716: and exists -- check if the query owner and the planner belong to the currently fetched group
5717: ( select 1 from msc_srp_user_groups planner
5718: where planner.user_id = c_planner
5719: and owner.group_id=planner.group_id
5720: )
5721: and rownum=1;