APPS.CS_CORE_UTIL dependencies on HZ_PARTIES

Line 205: FROM hz_parties

201:
202: IF p_customer_number <> fnd_api.g_miss_char THEN
203: BEGIN
204: SELECT party_id INTO x_customer_id
205: FROM hz_parties
206: WHERE party_number = p_customer_number;
207: EXCEPTION
208: WHEN no_data_found THEN
209: x_return_status := fnd_api.g_ret_sts_error;

Line 220: FROM hz_parties

216: END IF;
217: ELSE
218: BEGIN
219: SELECT party_id INTO x_customer_id
220: FROM hz_parties
221: WHERE party_name = p_customer_name;
222: EXCEPTION
223: WHEN no_data_found THEN
224: x_return_status := fnd_api.g_ret_sts_error;

Line 251: FROM hz_parties

247: x_return_status := fnd_api.g_ret_sts_success;
248:
249: -- Fetch name from database.
250: SELECT party_name INTO x_customer_name
251: FROM hz_parties
252: WHERE party_id = p_customer_id;
253:
254: EXCEPTION
255: WHEN no_data_found THEN

Line 575: FROM hz_parties

571: l_dummy VARCHAR2(1);
572: BEGIN
573: x_return_status := fnd_api.g_ret_sts_success;
574: SELECT 'x' INTO l_dummy
575: FROM hz_parties
576: WHERE party_id = p_customer_id
577: AND status = 'A';
578: EXCEPTION
579: WHEN no_data_found THEN