APPS.IBE_MSITE_PRTY_ACCSS_PVT dependencies on IBE_MSITES_B

Line 25: IS SELECT msite_id FROM ibe_msites_b

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

Line 34: -- Check if msite_id exists in ibe_msites_b

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