APPS.ASO_SALES_TEAM_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 162: FROM JTF_RS_ROLE_RELATIONS

158: AND Role_Type_Code IN ('TELESALES', 'SALES', 'FIELDSALES', 'PRM');
159:
160: CURSOR C_Get_Resource_Role (l_res NUMBER) IS
161: SELECT Role_Id
162: FROM JTF_RS_ROLE_RELATIONS
163: WHERE Role_Resource_Id = l_res
164: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
165:
166: CURSOR C_Get_Res_From_Srep (l_Srep VARCHAR2) IS

Line 1599: FROM JTF_RS_ROLE_RELATIONS

1595: --Commented Code End Yogeshwar (MOAC)
1596:
1597: CURSOR C_Get_Resource_Role (l_res NUMBER) IS
1598: SELECT Role_Id
1599: FROM JTF_RS_ROLE_RELATIONS
1600: WHERE Role_Resource_Id = l_res
1601: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
1602:
1603: CURSOR C_Get_Res_From_Srep (l_Srep VARCHAR2) IS

Line 2043: FROM JTF_RS_ROLE_RELATIONS

2039: AND Role_Type_Code IN ('TELESALES', 'SALES', 'FIELDSALES', 'PRM');
2040:
2041: CURSOR C_Get_Resource_Role (l_res NUMBER) IS
2042: SELECT Role_Id
2043: FROM JTF_RS_ROLE_RELATIONS
2044: WHERE Role_Resource_Id = l_res
2045: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
2046:
2047: CURSOR C_Get_Res_From_Srep (l_Srep VARCHAR2) IS