APPS.HZ_ACCOUNT_MERGE_PUB dependencies on HZ_CUST_ACCOUNTS

Line 48: FROM HZ_CUST_ACCOUNTS

44: l_count NUMBER;
45:
46: CURSOR get_account(c_account_id NUMBER) IS
47: SELECT cust_account_id, party_id, account_number, orig_system_reference, status
48: FROM HZ_CUST_ACCOUNTS
49: WHERE cust_account_id = c_account_id
50: AND status in ('A','I');
51:
52:

Line 90: FROM HZ_CUST_ACCOUNTS

86: /* Fetch account details using account_number */
87:
88: SELECT cust_account_id, party_id, account_number, orig_system_reference , status
89: INTO l_account_id, x_party_id,l_account_number, l_account_osr, x_account_status
90: FROM HZ_CUST_ACCOUNTS
91: WHERE account_number = p_account_number
92: AND status in ('A','I');
93:
94: EXCEPTION

Line 129: p_owner_table_name => 'HZ_CUST_ACCOUNTS');

125: -- Get how many rows return
126: l_count := HZ_MOSR_VALIDATE_PKG.get_orig_system_ref_count(
127: p_orig_system => p_account_os,
128: p_orig_system_reference => p_account_osr,
129: p_owner_table_name => 'HZ_CUST_ACCOUNTS');
130:
131: IF (l_count = 0) THEN
132:
133: FND_MESSAGE.SET_NAME('AR','HZ_CM_INV_OSOSR');

Line 143: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

139: -- Get owner_table_id
140: HZ_ORIG_SYSTEM_REF_PUB.get_owner_table_id(
141: p_orig_system => p_account_os,
142: p_orig_system_reference => p_account_osr,
143: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
144: x_owner_table_id => l_owner_table_id,
145: x_return_status => x_return_status);
146:
147: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN