APPS.IBE_MSITE_PRTY_ACCSS_PVT dependencies on HZ_PARTIES

Line 88: IS SELECT party_id FROM hz_parties

84: l_api_version CONSTANT NUMBER := 1.0;
85: l_tmp_id NUMBER;
86:
87: CURSOR c1(l_c_party_id IN NUMBER)
88: IS SELECT party_id FROM hz_parties
89: WHERE party_id = l_c_party_id;
90:
91: BEGIN
92:

Line 96: -- Check if party_id exists in hz_parties

92:
93: -- Initialize status to SUCCESS
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:
96: -- Check if party_id exists in hz_parties
97: OPEN c1(p_party_id);
98: FETCH c1 INTO l_tmp_id;
99: IF (c1%NOTFOUND) THEN
100: CLOSE c1;