APPS.IBE_MSITE_INFORMATION_PVT dependencies on IBE_MSITES_B

Line 28: IS SELECT msite_id FROM ibe_msites_b

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

Line 37: -- Check if msite_id exists in ibe_msites_b

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