APPS.ASO_SALES_TEAM_PVT dependencies on JTF_RS_ROLES_B

Line 156: FROM JTF_RS_ROLES_B

152: */
153: --Commented Code End Yogeshwar (MOAC)
154: CURSOR C_Get_Role_From_Code (l_code VARCHAR2) IS
155: SELECT Role_Id
156: FROM JTF_RS_ROLES_B
157: WHERE Role_Code = l_code
158: AND Role_Type_Code IN ('TELESALES', 'SALES', 'FIELDSALES', 'PRM');
159:
160: CURSOR C_Get_Resource_Role (l_res NUMBER) IS

Line 790: FROM JTF_RS_ROLES_B A

786: lx_gen_return_Rec.full_access_flag(i),
787: lx_gen_return_Rec.terr_id(i),
788: 'Y',
789: DECODE(lx_gen_return_Rec.role(i),NULL,NULL,A.Role_Id)
790: FROM JTF_RS_ROLES_B A
791: WHERE A.Role_Code = NVL(lx_gen_return_Rec.role(i),A.Role_Code)
792: AND rownum = 1;
793:
794: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 847: FROM JTF_RS_ROLES_B

843: END IF;
844: DELETE FROM ASO_STEAM_TEMP
845: WHERE Role_Id IS NOT NULL
846: AND Role_Id NOT IN ( SELECT Role_Id
847: FROM JTF_RS_ROLES_B
848: WHERE Role_Type_Code IN ('TELESALES', 'SALES','FIELDSALES','PRM'));
849:
850: IF aso_debug_pub.g_debug_flag = 'Y' THEN
851: select count(*) into i from aso_steam_temp;

Line 2037: FROM JTF_RS_ROLES_B

2033: AND Resource_Id = l_res;
2034:
2035: CURSOR C_Get_Role_From_Code (l_code VARCHAR2) IS
2036: SELECT Role_Id
2037: FROM JTF_RS_ROLES_B
2038: WHERE Role_Code = l_code
2039: AND Role_Type_Code IN ('TELESALES', 'SALES', 'FIELDSALES', 'PRM');
2040:
2041: CURSOR C_Get_Resource_Role (l_res NUMBER) IS