APPS.CSM_GROUP_DOWNLOAD_PVT dependencies on JTF_RS_GROUPS_B

Line 152: FROM JTF_RS_GROUPS_B jrgb

148: --CURSOR declarations
149: CURSOR c_rel_group_ins(b_group_id IN NUMBER)
150: IS
151: SELECT 1
152: FROM JTF_RS_GROUPS_B jrgb
153: WHERE jrgb.GROUP_ID = b_group_id
154: AND NVL(jrgb.END_DATE_ACTIVE,SYSDATE) >= TRUNC(SYSDATE);
155:
156: --variable declarations

Line 171: x_error_message := 'the related group id -'||p_group_id|| ' does not exists in JTF_RS_GROUPS_B base table';

167: OPEN c_rel_group_ins(p_group_id);
168: FETCH c_rel_group_ins INTO l_chk_rel_grp;
169:
170: IF (c_rel_group_ins%NOTFOUND) THEN
171: x_error_message := 'the related group id -'||p_group_id|| ' does not exists in JTF_RS_GROUPS_B base table';
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175: CLOSE c_rel_group_ins;