APPS.HZ_PROFILE_MERGE_PKG dependencies on HZ_CUST_PROFILE_AMTS

Line 88: FROM hz_cust_profile_amts

84: CURSOR c1 IS
85: SELECT cust_acct_profile_amt_id,
86: cust_account_profile_id,
87: currency_code
88: FROM hz_cust_profile_amts
89: WHERE cust_account_profile_id = p_to_profile_id;
90: l_rec c1%ROWTYPE;
91: Ret NUMBER := FND_API.G_MISS_NUM;
92: BEGIN

Line 116: FROM hz_cust_profile_amts

112: CURSOR c1 IS
113: SELECT cust_acct_profile_amt_id,
114: cust_account_profile_id,
115: currency_code
116: FROM hz_cust_profile_amts
117: WHERE cust_account_profile_id = p_from_profile_id;
118: l_rec c1%ROWTYPE;
119: l_to_prof_amt_id NUMBER;
120: l_temp NUMBER;

Line 135: UPDATE hz_cust_profile_amts

131: p_currency_code => l_rec.currency_code);
132:
133: IF l_to_prof_amt_id = FND_API.G_MISS_NUM THEN
134:
135: UPDATE hz_cust_profile_amts
136: SET cust_account_profile_id = p_to_profile_id,
137: last_update_date = hz_utility_pub.last_update_date,
138: last_updated_by = hz_utility_pub.user_id,
139: last_update_login = hz_utility_pub.last_update_login,