APPS.POS_PARTY_MERGE_PKG dependencies on HZ_PARTY_SITES

Line 82: from pos_acnt_addr_req req, pos_supplier_mappings pmap, hz_party_sites hps

78:
79: UNION
80:
81: select 1
82: from pos_acnt_addr_req req, pos_supplier_mappings pmap, hz_party_sites hps
83: where req.request_status = 'PENDING'
84: and req.request_type = 'ADDRESS'
85: and req.mapping_id = pmap.mapping_id
86: and hps.party_site_id = req.party_site_id

Line 283: FROM hz_party_sites

279: l_to_party_id NUMBER;
280:
281: CURSOR l_party_id_cur(p_party_site_id NUMBER) IS
282: SELECT party_id
283: FROM hz_party_sites
284: WHERE party_site_id = p_party_site_id;
285:
286: l_return_status VARCHAR2(2);
287: l_module fnd_log_messages.module%TYPE;

Line 292: FROM hz_party_sites

288: l_invalid_param VARCHAR2(30);
289:
290: CURSOR l_party_site_cur(p_party_site_id NUMBER) IS
291: SELECT party_id
292: FROM hz_party_sites
293: WHERE party_site_id = p_party_site_id;
294:
295: CURSOR l_party_cur(p_party_id NUMBER) IS
296: SELECT party_id

Line 341: IF p_parent_entity_name NOT IN ('HZ_PARTIES', 'HZ_PARTY_SITES') THEN

337: RETURN;
338:
339: END IF;
340:
341: IF p_parent_entity_name NOT IN ('HZ_PARTIES', 'HZ_PARTY_SITES') THEN
342: fnd_message.set_name('POS','POS_PTYM_BAD_PARENT_ENTITY');
343: fnd_message.set_token('PARENT_ENTITY_NAME', p_parent_entity_name);
344: fnd_msg_pub.ADD;
345: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 392: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN

388: RETURN;
389: END IF;
390: CLOSE l_party_cur;
391:
392: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN
393:
394: OPEN l_party_site_cur(p_from_fk_id);
395: FETCH l_party_site_cur INTO l_from_party_id;
396: IF l_party_site_cur%notfound THEN