DBA Data[Home] [Help]

APPS.OZF_PARTY_MERGE_PVT dependencies on OZF_ACTIVITY_CUSTOMERS

Line 617: FROM ozf_activity_customers

613: l_merge_reason_code VARCHAR2(30);
614: /*
615: CURSOR c_object_id IS
616: SELECT object_id
617: FROM ozf_activity_customers
618: WHERE party_id = p_from_fk_id;
619:
620: CURSOR c_is_duplicate(l_list_header_id NUMBER, l_party_id NUMBER) IS
621: SELECT 'Y'

Line 701: UPDATE ozf_activity_customers

697: DELETE FROM OZF_offer_parties
698: WHERE qp_list_header_id = l_list_header_id.qp_list_header_id
699: AND party_id = p_from_fk_id;
700: ELSE*/
701: UPDATE ozf_activity_customers
702: SET party_id = p_to_fk_id
703: ,last_update_date = hz_utility_pub.last_update_date
704: ,last_updated_by = hz_utility_pub.user_id
705: ,last_update_login = hz_utility_pub.last_update_login