APPS.AHL_WF_NOTIFICATION_PVT dependencies on AHL_JTF_RS_EMP_V

Line 188: FROM AHL_JTF_RS_EMP_V

184:
185: -- 3) get the employee id of the approver
186: BEGIN
187: SELECT employee_id INTO l_employee_id
188: FROM AHL_JTF_RS_EMP_V
189: WHERE resource_id = l_aprvr_resource_id;
190: EXCEPTION
191: WHEN OTHERS THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;

Line 236: FROM AHL_JTF_RS_EMP_V

232: -- SET PROCESS OWNER
233: -- 1) get the employee id of the requester
234: BEGIN
235: SELECT employee_id INTO l_employee_id
236: FROM AHL_JTF_RS_EMP_V
237: WHERE user_id = FND_GLOBAL.USER_ID;
238: EXCEPTION
239: WHEN OTHERS THEN
240: x_return_status := FND_API.G_RET_STS_ERROR;