APPS.IBY_HZ_UNIFICATION_PKG dependencies on HZ_PARTY_SITES

Line 130: (SELECT party_id FROM hz_party_sites WHERE party_site_id = ci_site_id) np

126: (SELECT payment_function,payee_party_id,party_site_id,
127: supplier_site_id,org_type,org_id
128: FROM iby_external_payees_all
129: WHERE (ext_payee_id = ci_payee_id)) mfrom,
130: (SELECT party_id FROM hz_party_sites WHERE party_site_id = ci_site_id) np
131: WHERE
132: mto.ext_payee_id <> ci_payee_id
133: AND mto.payment_function = mfrom.payment_function
134: --

Line 181: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITES') THEN

177: p_to_id := p_from_id;
178: ELSE
179: p_to_id := l_dup_id;
180: END IF;
181: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITES') THEN
182:
183: OPEN c_dupesite(p_from_id,p_to_fk_id);
184: FETCH c_dupesite INTO l_dup_id, l_new_party_id;
185: CLOSE c_dupesite;

Line 815: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITES') THEN

811: last_updated_by = hz_utility_pub.user_id,
812: last_update_login = hz_utility_pub.last_update_login
813: WHERE (document_payable_id = p_from_id);
814:
815: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITES') THEN
816:
817: UPDATE iby_docs_payable_all
818: SET party_site_id = p_to_fk_id,
819: -- party site may be transferred to a new party

Line 822: (SELECT party_id FROM hz_party_sites

818: SET party_site_id = p_to_fk_id,
819: -- party site may be transferred to a new party
820: payee_party_id =
821: DECODE(payee_party_id, NULL,payee_party_id,
822: (SELECT party_id FROM hz_party_sites
823: WHERE party_site_id = p_to_fk_id) ),
824: last_update_date = hz_utility_pub.last_update_date,
825: last_updated_by = hz_utility_pub.user_id,
826: last_update_login = hz_utility_pub.last_update_login

Line 903: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITES') THEN

899: last_updated_by = hz_utility_pub.user_id,
900: last_update_login = hz_utility_pub.last_update_login
901: WHERE (payment_id = p_from_id);
902:
903: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITES') THEN
904:
905: UPDATE iby_payments_all
906: SET party_site_id = p_to_fk_id,
907: -- party site may be transferred to a new party

Line 910: (SELECT party_id FROM hz_party_sites

906: SET party_site_id = p_to_fk_id,
907: -- party site may be transferred to a new party
908: payee_party_id =
909: DECODE(payee_party_id, NULL,payee_party_id,
910: (SELECT party_id FROM hz_party_sites
911: WHERE party_site_id = p_to_fk_id) ),
912: last_update_date = hz_utility_pub.last_update_date,
913: last_updated_by = hz_utility_pub.user_id,
914: last_update_login = hz_utility_pub.last_update_login