APPS.AMS_PARTY_MERGE_PVT dependencies on OZF_CUST_TRD_PRFLS_ALL

Line 1017: from ozf_cust_trd_prfls_all

1013: l_return_flag varchar2(30);
1014:
1015: CURSOR get_party_data(p_party_id in number) IS
1016: select trade_profile_id
1017: from ozf_cust_trd_prfls_all
1018: where party_id = p_party_id
1019: and cust_account_id is null;
1020:
1021: BEGIN

Line 1086: UPDATE OZF_CUST_TRD_PRFLS_ALL

1082: l_to_party_exists := check_party_exists(p_to_fk_id);
1083:
1084: IF l_to_party_exists = 'FALSE' THEN
1085: -- update the from party profile to to_party
1086: UPDATE OZF_CUST_TRD_PRFLS_ALL
1087: SET party_id = p_to_fk_id,
1088: last_update_date = hz_utility_pub.last_update_date,
1089: last_updated_by = hz_utility_pub.user_id,
1090: last_update_login = hz_utility_pub.last_update_login,

Line 1097: DELETE FROM OZF_CUST_TRD_PRFLS_ALL

1093: program_update_date = sysdate
1094: where party_id = p_from_fk_id;
1095: ELSIF l_to_party_exists = 'TRUE' THEN
1096: -- delete the from party profile since to_party profile exists
1097: DELETE FROM OZF_CUST_TRD_PRFLS_ALL
1098: WHERE party_id = p_from_fk_id
1099: AND cust_account_id is null;
1100: END IF;
1101: