DBA Data[Home] [Help]

APPS.CAC_SYNC_CONTACT_PREF_PVT dependencies on HZ_PARTY_PREFERENCES

Line 19: FROM hz_party_preferences

15: )
16: IS
17: CURSOR c_preference IS
18: SELECT party_preference_id
19: FROM hz_party_preferences
20: WHERE party_id = p_party_id
21: AND category = p_category
22: AND value_number = p_value_number
23: AND preference_code = p_preference_code

Line 72: UPDATE hz_party_preferences

68:
69:
70: -- Correct last_update_date
71: IF p_last_sync_date IS NOT NULL THEN
72: UPDATE hz_party_preferences
73: SET last_update_date = p_last_sync_date
74: WHERE party_id = p_party_id
75: AND category = p_category
76: AND preference_code = p_preference_code