DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_SRP_GROUPS

Line 5704: msc_srp_groups

5700: cursor group_by_id (c_group_id number) is
5701: select
5702: group_name
5703: from
5704: msc_srp_groups
5705: where group_id = c_group_id;
5706:
5707: cursor group_by_owner(c_owner varchar2, c_planner varchar2) is
5708: select

Line 5712: msc_srp_groups g

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
5716: and exists -- check if the query owner and the planner belong to the currently fetched group