APPS.HZ_DUP_MERGE_PUB dependencies on HZ_PARTIES

Line 56: FROM HZ_PARTIES

52: x_msg_data OUT NOCOPY VARCHAR2
53: ) IS
54: CURSOR is_pty_valid(l_pty_id NUMBER) IS
55: SELECT status, party_id
56: FROM HZ_PARTIES
57: WHERE party_id = l_pty_id
58: AND status in ('A', 'I');
59:
60: l_ss_flag VARCHAR2(1);

Line 102: p_owner_table_name => 'HZ_PARTIES');

98: -- Get how many rows return
99: l_count := HZ_MOSR_VALIDATE_PKG.get_orig_system_ref_count(
100: p_orig_system => px_os,
101: p_orig_system_reference => px_osr,
102: p_owner_table_name => 'HZ_PARTIES');
103:
104: IF(l_count = 1) THEN
105: -- Get owner_table_id
106: HZ_ORIG_SYSTEM_REF_PUB.get_owner_table_id(

Line 109: p_owner_table_name => 'HZ_PARTIES',

105: -- Get owner_table_id
106: HZ_ORIG_SYSTEM_REF_PUB.get_owner_table_id(
107: p_orig_system => px_os,
108: p_orig_system_reference => px_osr,
109: p_owner_table_name => 'HZ_PARTIES',
110: x_owner_table_id => l_owner_table_id,
111: x_return_status => x_return_status);
112:
113: OPEN is_pty_valid(l_owner_table_id);

Line 261: from HZ_PARTIES

257: ) IS
258:
259: CURSOR get_party_name(l_party_id NUMBER) is
260: select party_name
261: from HZ_PARTIES
262: where party_id = l_party_id;
263:
264: l_jtf_note_id number;
265: l_dup_set_id number;