DBA Data[Home] [Help]

APPS.AML_SALES_LEADS_V2_PUB dependencies on JTF_RS_ROLE_RELATIONS

Line 77: JTF_RS_ROLE_RELATIONS rrel,

73: CURSOR c_get_group_id (c_resource_id NUMBER)
74: IS
75: SELECT MAX(grp.group_id) salesgroup_id
76: FROM JTF_RS_GROUP_MEMBERS mem,
77: JTF_RS_ROLE_RELATIONS rrel,
78: JTF_RS_ROLES_B role,
79: JTF_RS_GROUP_USAGES u,
80: JTF_RS_GROUPS_B grp
81: WHERE mem.group_member_id = rrel.role_resource_id AND