DBA Data[Home] [Help]

APPS.PV_ASSIGN_UTIL_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 1033: jtf_rs_role_relations rel,

1029: pv_partner_accesses PT_ACC,
1030: pv_partner_profiles PT_PROF,
1031: jtf_rs_resource_extns extn,
1032: per_all_people_f per,
1033: jtf_rs_role_relations rel,
1034: jtf_rs_roles_b role,
1035: fnd_user usr
1036: WHERE
1037: pt_acc.partner_id = pc_partner_id and

Line 1165: jtf_rs_role_relations rel,

1161: pv_partner_accesses PT_ACC,
1162: pv_partner_profiles PT_PROF,
1163: jtf_rs_resource_extns extn,
1164: hz_relationships emp,
1165: jtf_rs_role_relations rel,
1166: jtf_rs_roles_b role
1167: where
1168: PT_ACC.partner_id = pc_partner_id and
1169: PT_ACC.vad_partner_id = pc_vad_id and

Line 2923: JTF_RS_ROLE_RELATIONS rrel,

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,
2927: JTF_RS_RESOURCE_EXTNS RES