DBA Data[Home] [Help]

APPS.HZ_PARTY_USG_ASSIGNMENT_PVT dependencies on HZ_PARTIES

Line 293: FROM hz_parties

289: p_party_id NUMBER
290: ) IS
291: SELECT party_type,
292: party_name
293: FROM hz_parties
294: WHERE party_id = p_party_id
295: AND status IN ('A', 'I');
296:
297: /*

Line 665: fnd_message.set_token('TABLE', 'hz_parties');

661: IF (c_party%NOTFOUND) THEN
662: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
663: fnd_message.set_token('FK', 'party_id');
664: fnd_message.set_token('COLUMN', 'party_id');
665: fnd_message.set_token('TABLE', 'hz_parties');
666: fnd_msg_pub.add;
667: x_return_status := fnd_api.G_RET_STS_ERROR;
668: END IF;
669: CLOSE c_party;

Line 3014: FROM hz_parties p

3010: p_party_id NUMBER,
3011: p_party_name VARCHAR2
3012: ) IS
3013: SELECT null
3014: FROM hz_parties p
3015: WHERE p.party_name = p_party_name
3016: AND p.party_type = 'ORGANIZATION'
3017: AND p.party_id <> p_party_id
3018: AND p.status IN ('A', 'I')