APPS.ASO_SALES_TEAM_PVT dependencies on JTF_RS_ROLES_B

Line 137: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,

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,
141: jtf_rs_groups_b g,

Line 144: jtf_rs_roles_b r,

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)
148: AND NVL(g.end_date_active,SYSDATE)

Line 193: jtf_rs_roles_b r, jtf_rs_resource_extns res,

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
197: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,

Line 199: jtf_rs_roles_b tr, jtf_rs_resource_extns tres

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)
203: AND tu.team_id = t.team_id

Line 433: FROM JTF_RS_ROLES_B

429: */
430: --Commented Code End Yogeshwar (MOAC)
431: CURSOR C_Get_Role_From_Code (l_code VARCHAR2) IS
432: SELECT Role_Id
433: FROM JTF_RS_ROLES_B
434: WHERE Role_Code = l_code
435: AND Role_Type_Code IN ('TELESALES', 'SALES', 'FIELDSALES', 'PRM');
436:
437: CURSOR C_Get_Resource_Role (l_res NUMBER) IS

Line 1081: FROM JTF_RS_ROLES_B A

1077: lx_gen_return_Rec.full_access_flag(i),
1078: lx_gen_return_Rec.terr_id(i),
1079: 'Y',
1080: DECODE(lx_gen_return_Rec.role(i),NULL,NULL,A.Role_Id)
1081: FROM JTF_RS_ROLES_B A
1082: WHERE A.Role_Code = NVL(lx_gen_return_Rec.role(i),A.Role_Code)
1083: AND rownum = 1;
1084:
1085: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1138: FROM JTF_RS_ROLES_B

1134: END IF;
1135: DELETE FROM ASO_STEAM_TEMP
1136: WHERE Role_Id IS NOT NULL
1137: AND Role_Id NOT IN ( SELECT Role_Id
1138: FROM JTF_RS_ROLES_B
1139: WHERE Role_Type_Code IN ('TELESALES', 'SALES','FIELDSALES','PRM'));
1140:
1141: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1142: select count(*) into i from aso_steam_temp;

Line 1777: jtf_rs_roles_b r, jtf_rs_resource_extns res

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)
1781: AND u.group_id = g.group_id

Line 2476: FROM JTF_RS_ROLES_B

2472: AND Resource_Id = l_res;
2473:
2474: CURSOR C_Get_Role_From_Code (l_code VARCHAR2) IS
2475: SELECT Role_Id
2476: FROM JTF_RS_ROLES_B
2477: WHERE Role_Code = l_code
2478: AND Role_Type_Code IN ('TELESALES', 'SALES', 'FIELDSALES', 'PRM');
2479:
2480: CURSOR C_Get_Resource_Role (l_res NUMBER) IS