APPS.JTF_MSITE_PRTY_ACCSS_PVT dependencies on JTF_MSITES_B

Line 21: IS SELECT msite_id FROM jtf_msites_b

17: l_api_version CONSTANT NUMBER := 1.0;
18: l_tmp_id NUMBER;
19:
20: CURSOR c1(l_c_msite_id IN NUMBER)
21: IS SELECT msite_id FROM jtf_msites_b
22: WHERE msite_id = l_c_msite_id
23: AND master_msite_flag = 'N';
24:
25: BEGIN

Line 30: -- Check if msite_id exists in jtf_msites_b

26:
27: -- Initialize status to SUCCESS
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:
30: -- Check if msite_id exists in jtf_msites_b
31: OPEN c1(p_msite_id);
32: FETCH c1 INTO l_tmp_id;
33: IF (c1%NOTFOUND) THEN
34: CLOSE c1;