APPS.IBE_MSITE_RESP_PVT dependencies on IBE_MSITES_B

Line 27: IS SELECT msite_id FROM ibe_msites_b

23: l_api_version CONSTANT NUMBER := 1.0;
24: l_tmp_id NUMBER;
25:
26: CURSOR c1(l_c_msite_id IN NUMBER)
27: IS SELECT msite_id FROM ibe_msites_b
28: WHERE msite_id = l_c_msite_id
29: AND master_msite_flag = 'N' and site_type = 'I';
30:
31: BEGIN

Line 36: -- Check if msite_id exists in ibe_msites_b

32:
33: -- Initialize status to SUCCESS
34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35:
36: -- Check if msite_id exists in ibe_msites_b
37: OPEN c1(p_msite_id);
38: FETCH c1 INTO l_tmp_id;
39: IF (c1%NOTFOUND) THEN
40: CLOSE c1;