APPS.OZF_PARTY_MERGE_PVT dependencies on OZF_CUST_TRD_PRFLS_ALL

Line 15: from ozf_cust_trd_prfls_all

11: l_return_flag varchar2(30);
12:
13: CURSOR get_party_data(p_party_id in number) IS
14: select trade_profile_id
15: from ozf_cust_trd_prfls_all
16: where party_id = p_party_id
17: and cust_account_id is null;
18:
19: BEGIN

Line 85: UPDATE OZF_CUST_TRD_PRFLS_ALL

81: l_to_party_exists := check_party_exists(p_to_fk_id);
82:
83: IF l_to_party_exists = 'FALSE' THEN
84: -- update the from party profile to to_party
85: UPDATE OZF_CUST_TRD_PRFLS_ALL
86: SET party_id = p_to_fk_id,
87: last_update_date = hz_utility_pub.last_update_date,
88: last_updated_by = hz_utility_pub.user_id,
89: last_update_login = hz_utility_pub.last_update_login,

Line 96: DELETE FROM OZF_CUST_TRD_PRFLS_ALL

92: program_update_date = sysdate
93: where party_id = p_from_fk_id;
94: ELSIF l_to_party_exists = 'TRUE' THEN
95: -- delete the from party profile since to_party profile exists
96: DELETE FROM OZF_CUST_TRD_PRFLS_ALL
97: WHERE party_id = p_from_fk_id
98: AND cust_account_id is null;
99: END IF;
100: