APPS.ARH_DQM_TREE_HELPER dependencies on HZ_PARTY_SITES

Line 90: FROM hz_party_sites

86: RETURN VARCHAR2
87: IS
88: CURSOR c1 IS
89: SELECT 'Y'
90: FROM hz_party_sites
91: WHERE party_site_id = p_ps_id
92: AND party_id = p_party_id;
93: ret VARCHAR2(1);
94: BEGIN

Line 293: -- + flag x_type to 'HZ_PARTY_SITES'

289:
290: FUNCTION party_or_site_from_cpt
291: ---------------------------------------------------------------------------------------
292: -- RETURN party_site_id if contact_point at PS
293: -- + flag x_type to 'HZ_PARTY_SITES'
294: -- RETURN party_id if contact_point at HZ_PARTIES
295: -- + flag x_type to 'ORGANIZATION' if the party is type 'ORGANIZATION'
296: -- flag x_type to 'PARTY_RELATIONSHIP' if the party is type 'PARTY_RELATIONSHIP'
297: -- RETURN -9999 if contact_point not found

Line 453: ELSIF l_type = 'HZ_PARTY_SITES' THEN

449: x_return_status=> x_return_status,
450: x_msg_count=> x_msg_count,
451: x_msg_data => x_msg_data);
452:
453: ELSIF l_type = 'HZ_PARTY_SITES' THEN
454: treatment_party_site(p_ps_id => l_id,
455: p_pty_id => p_pty_id,
456: p_ctx_id => p_ctx_id,
457: x_return_status=> x_return_status,