APPS.PVX_MISC_PVT dependencies on JTF_RS_ROLES_VL

Line 105: FROM JTF_RS_RESOURCE_EXTNS RES ,JTF_RS_ROLE_RELATIONS RREL ,JTF_RS_ROLES_VL ROLE

101: -- "BUG:1706709"
102: -- Cursor : c_sales_group
103: CURSOR c_sales_group (cv_salesforce_id IN NUMBER) IS
104: SELECT GRPREL.group_id
105: FROM JTF_RS_RESOURCE_EXTNS RES ,JTF_RS_ROLE_RELATIONS RREL ,JTF_RS_ROLES_VL ROLE
106: ,JTF_RS_GROUPS_TL GROUPS ,JTF_RS_GROUP_USAGES U ,JTF_RS_GROUP_MEMBERS GRPREL
107: WHERE RES.category = 'EMPLOYEE' AND ROLE.role_type_code in ('SALES','TELESALES','FIELDSALES','PRM')
108: AND RREL.role_id = ROLE.role_id AND GROUPS.language = userenv('LANG') AND GRPREL.group_id = GROUPS.group_id
109: AND NVL(RREL.delete_flag,'N') = 'N' AND RREL.start_date_active <= sysdate

Line 948: FROM JTF_RS_ROLES_VL

944:
945: -- Cursor : c_role_detail
946: CURSOR c_role_detail (cv_role_code IN VARCHAR2) IS
947: SELECT role_id
948: FROM JTF_RS_ROLES_VL
949: WHERE role_code = cv_role_code;
950: -- Cursor related variables
951: l_role_id NUMBER;
952:

Line 1377: FROM JTF_RS_ROLES_VL

1373:
1374: -- Cursor : c_role_detail
1375: CURSOR c_role_detail (cv_role_code IN VARCHAR2) IS
1376: SELECT role_id
1377: FROM JTF_RS_ROLES_VL
1378: WHERE role_code = cv_role_code;
1379: -- Cursor related variables
1380: l_role_id NUMBER;
1381: