APPS.PVX_MISC_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 106: ,JTF_RS_GROUPS_TL GROUPS ,JTF_RS_GROUP_USAGES U ,JTF_RS_GROUP_MEMBERS GRPREL

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
110: AND NVL(RREL.end_date_active,sysdate) >= sysdate AND U.group_id = GRPREL.group_id

Line 1257: JTF_RS_GROUP_MEMBERS_PUB.Create_Resource_Group_Members(

1253: PVX_Utility_PVT.debug_message(l_full_name ||': Create_Resource_Group_Members');
1254: END IF;
1255:
1256: -- Call the Create_Group_Usage API to create the Group Usage
1257: JTF_RS_GROUP_MEMBERS_PUB.Create_Resource_Group_Members(
1258: p_api_version => 1.0
1259: ,p_init_msg_list => FND_API.g_false
1260: -- ,p_commit => FND_API.g_true
1261: ,x_return_status => x_return_status

Line 1413: JTF_RS_GROUP_MEMBERS_PUB.Create_Resource_Group_Members(

1409: PVX_Utility_PVT.debug_message(l_full_name ||': Create_Resource_Group_Members');
1410: END IF;
1411:
1412: -- Call the Create_Group_Usage API to create the Group Usage
1413: JTF_RS_GROUP_MEMBERS_PUB.Create_Resource_Group_Members(
1414: p_api_version => 1.0
1415: ,p_init_msg_list => FND_API.g_false
1416: -- ,p_commit => FND_API.g_true
1417: ,x_return_status => x_return_status