APPS.MSC_GET_NAME dependencies on MSC_SRP_GROUPS

Line 5132: msc_srp_groups

5128: cursor group_by_id (c_group_id number) is
5129: select
5130: group_name
5131: from
5132: msc_srp_groups
5133: where group_id = c_group_id;
5134:
5135: cursor group_by_owner(c_owner varchar2, c_planner varchar2) is
5136: select

Line 5140: msc_srp_groups g

5136: select
5137: g.group_name
5138: from
5139: msc_srp_user_groups owner,
5140: msc_srp_groups g
5141: where
5142: owner.user_id = c_owner
5143: and owner.group_id=g.group_id
5144: and exists -- check if the query owner and the planner belong to the currently fetched group