APPS.JTF_MSITE_PRTY_ACCSS_PVT dependencies on HZ_PARTIES

Line 84: IS SELECT party_id FROM hz_parties

80: l_api_version CONSTANT NUMBER := 1.0;
81: l_tmp_id NUMBER;
82:
83: CURSOR c1(l_c_party_id IN NUMBER)
84: IS SELECT party_id FROM hz_parties
85: WHERE party_id = l_c_party_id;
86:
87: BEGIN
88:

Line 92: -- Check if party_id exists in hz_parties

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