APPS.ASO_SALES_TEAM_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 136: jtf_rs_team_usages TU, jtf_rs_role_relations TRR,

132: MIN(T.team_id) team_id,
133: TRES.CATEGORY resource_category,
134: MIN(TRES.source_id) person_id
135: FROM jtf_rs_team_members TM, jtf_rs_teams_b T,
136: jtf_rs_team_usages TU, jtf_rs_role_relations TRR,
137: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,
138: (
139: SELECT m.group_id group_id, m.resource_id resource_id
140: FROM jtf_rs_group_members m,

Line 143: jtf_rs_role_relations rr,

139: SELECT m.group_id group_id, m.resource_id resource_id
140: FROM jtf_rs_group_members m,
141: jtf_rs_groups_b g,
142: jtf_rs_group_usages u,
143: jtf_rs_role_relations rr,
144: jtf_rs_roles_b r,
145: jtf_rs_resource_extns res
146: WHERE m.group_id = g.group_id
147: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)

Line 192: jtf_rs_group_usages u, jtf_rs_role_relations rr,

188: MIN(m.person_id) person_id2, MIN(m.group_id) group_id,
189: MIN(jtm.team_id) team_id, res.CATEGORY resource_category,
190: MIN(res.source_id) person_id
191: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
192: jtf_rs_group_usages u, jtf_rs_role_relations rr,
193: jtf_rs_roles_b r, jtf_rs_resource_extns res,
194: (
195: SELECT tm.team_resource_id group_id,
196: t.team_id team_id

Line 198: jtf_rs_team_usages tu,jtf_rs_role_relations trr,

194: (
195: SELECT tm.team_resource_id group_id,
196: t.team_id team_id
197: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,
198: jtf_rs_team_usages tu,jtf_rs_role_relations trr,
199: jtf_rs_roles_b tr, jtf_rs_resource_extns tres
200: WHERE tm.team_id = t.team_id
201: AND SYSDATE BETWEEN NVL(t.start_date_active,SYSDATE)
202: AND NVL(t.end_date_active,SYSDATE)

Line 439: FROM JTF_RS_ROLE_RELATIONS

435: AND Role_Type_Code IN ('TELESALES', 'SALES', 'FIELDSALES', 'PRM');
436:
437: CURSOR C_Get_Resource_Role (l_res NUMBER) IS
438: SELECT Role_Id
439: FROM JTF_RS_ROLE_RELATIONS
440: WHERE Role_Resource_Id = l_res
441: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
442:
443: CURSOR C_Get_Res_From_Srep (l_Srep VARCHAR2) IS

Line 1776: jtf_rs_group_usages u, jtf_rs_role_relations rr,

1772: SELECT min(m.resource_id) resource_id,
1773: res.category resource_category,
1774: m.group_id group_id, min(res.source_id) person_id
1775: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
1776: jtf_rs_group_usages u, jtf_rs_role_relations rr,
1777: jtf_rs_roles_b r, jtf_rs_resource_extns res
1778: WHERE m.group_id = g.group_id
1779: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)
1780: AND NVL(g.end_date_active,SYSDATE)

Line 2038: FROM JTF_RS_ROLE_RELATIONS

2034: --Commented Code End Yogeshwar (MOAC)
2035:
2036: CURSOR C_Get_Resource_Role (l_res NUMBER) IS
2037: SELECT Role_Id
2038: FROM JTF_RS_ROLE_RELATIONS
2039: WHERE Role_Resource_Id = l_res
2040: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
2041:
2042: CURSOR C_Get_Res_From_Srep (l_Srep VARCHAR2) IS

Line 2482: FROM JTF_RS_ROLE_RELATIONS

2478: AND Role_Type_Code IN ('TELESALES', 'SALES', 'FIELDSALES', 'PRM');
2479:
2480: CURSOR C_Get_Resource_Role (l_res NUMBER) IS
2481: SELECT Role_Id
2482: FROM JTF_RS_ROLE_RELATIONS
2483: WHERE Role_Resource_Id = l_res
2484: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
2485:
2486: CURSOR C_Get_Res_From_Srep (l_Srep VARCHAR2) IS