APPS.IEM_EMAIL_SERVERS_PVT dependencies on IEM_SERVER_GROUPS

Line 95: Select count(*) into l_grp_cnt from iem_server_groups

91: END IF;
92:
93: /*Check For Existing Server Group Id */
94:
95: Select count(*) into l_grp_cnt from iem_server_groups
96: where server_group_id=p_server_group_id
97: and rownum=1;
98: IF l_grp_cnt = 0 then
99: --FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_GRP');

Line 565: select count(*) into l_grp_cnt from iem_server_groups

561: end if;
562:
563: /*Check For Existing Server Group Id */
564: if p_server_group_id <> FND_API.G_MISS_NUM then
565: select count(*) into l_grp_cnt from iem_server_groups
566: where server_group_id=p_server_group_id
567: and rownum=1;
568: IF l_grp_cnt = 0 then
569: raise IEM_NON_EXISTENT_SERVER_GRP;