DBA Data[Home] [Help]

APPS.PV_ASSIGN_UTIL_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 1655: -- else we will use the group_id from jtf_rs_group_members

1651:
1652: l_temp varchar2(100);
1653:
1654: -- if the person belongs to more than 1 group, we will use the group_id in ASF_DEFAULT_GROUP_ROLE.
1655: -- else we will use the group_id from jtf_rs_group_members
1656:
1657: l_get_person_info_sql varchar2(500) :=
1658: 'select a.category, b.user_name, a.source_id ' ||
1659: 'from jtf_rs_resource_extns a, fnd_user b ' ||

Line 2922: FROM JTF_RS_GROUP_MEMBERS mem,

2918: 1,
2919: TO_CHAR(MAX(grp.group_id)),
2920: FND_PROFILE.VALUE_SPECIFIC('ASF_DEFAULT_GROUP_ROLE',
2921: MAX(RES.user_id))) salesgroup_id
2922: FROM JTF_RS_GROUP_MEMBERS mem,
2923: JTF_RS_ROLE_RELATIONS rrel,
2924: JTF_RS_ROLES_B role,
2925: JTF_RS_GROUP_USAGES u,
2926: JTF_RS_GROUPS_B grp,