APPS.HZ_MERGE_UTIL dependencies on HZ_PARTY_SITES

Line 15: SELECT party_site_id, location_id FROM HZ_PARTY_SITES

11: p_LAST_UPDATE_DATE DATE,
12: p_LAST_UPDATED_BY NUMBER) IS
13:
14: CURSOR c_from_ps_loc IS
15: SELECT party_site_id, location_id FROM HZ_PARTY_SITES
16: WHERE party_id = p_from_party_id
17: AND nvl(status, 'A') = 'A'
18: AND actual_content_source <> 'DNB';
19:

Line 21: SELECT party_site_id FROM HZ_PARTY_SITES

17: AND nvl(status, 'A') = 'A'
18: AND actual_content_source <> 'DNB';
19:
20: CURSOR c_dup_to_ps(cp_loc_id NUMBER) IS
21: SELECT party_site_id FROM HZ_PARTY_SITES
22: WHERE party_id = p_to_party_id
23: AND location_id = cp_loc_id
24: AND nvl(status, 'A') = 'A';
25:

Line 42: 'HZ_PARTY_SITES',

38: FETCH c_dup_to_ps INTO l_dup_ps_id;
39: IF c_dup_to_ps%FOUND THEN
40: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
41: p_batch_party_id,
42: 'HZ_PARTY_SITES',
43: l_ps_id,
44: l_dup_ps_id,
45: 'Y',
46: p_created_by,

Line 54: 'HZ_PARTY_SITES',

50: p_last_updated_by);
51: ELSE
52: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
53: p_batch_party_id,
54: 'HZ_PARTY_SITES',
55: l_ps_id,
56: l_ps_id,
57: 'N',
58: p_created_by,

Line 262: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l

258: CURSOR c_get_desc IS
259: SELECT nvl(ps.party_site_name, ps.party_site_number) || '(Address: ' ||
260: l.address1 || ',' ||l.address2||','||l.address3||','||l.address4||','|| l.city ||
261: ',' || l.county || ','|| l.state || ', ' || l.province || ','||l.postal_code || ',' || l.country||')'
262: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l
263: WHERE ps.party_site_id = p_party_site_id
264: AND ps.location_id = l.location_id;
265:
266: l_ps_address VARCHAR2(2000);