APPS.CSM_PARTY_ASSIGNMENT_PKG dependencies on HZ_PARTY_SITES

Line 48: FROM hz_party_sites hps

44: THEN
45:
46: SELECT COUNT(1)
47: INTO l_chk_party_site
48: FROM hz_party_sites hps
49: WHERE hps.party_id = p_party_id
50: AND hps.party_site_id = p_party_site_id;
51:
52: END IF;

Line 66: x_error_message := 'The party site records does not exists in the HZ PARTY SITES base table for the party - '||p_party_id|| ' and site -'||p_party_site_id;

62: ELSIF l_chk_party_site = 0
63:
64: THEN
65:
66: x_error_message := 'The party site records does not exists in the HZ PARTY SITES base table for the party - '||p_party_id|| ' and site -'||p_party_site_id;
67:
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69:
70: END IF;