APPS.FTE_PARTY_MERGE dependencies on FTE_LOCATION_PARAMETERS

Line 62: FROM fte_location_parameters

58: IF p_from_fk_id <> p_to_fk_id THEN
59: -- obtain lock on records to be updated.
60: SELECT facility_id
61: INTO l_facility_id
62: FROM fte_location_parameters
63: WHERE facility_contact_id = p_from_fk_id
64: FOR UPDATE NOWAIT;
65: IF (p_parent_entity_name = 'HZ_PARTIES') THEN
66:

Line 67: UPDATE fte_location_parameters

63: WHERE facility_contact_id = p_from_fk_id
64: FOR UPDATE NOWAIT;
65: IF (p_parent_entity_name = 'HZ_PARTIES') THEN
66:
67: UPDATE fte_location_parameters
68: SET facility_contact_id = p_to_fk_id,
69: last_update_date = hz_utility_v2pub.last_update_date,
70: last_updated_by = hz_utility_v2pub.user_id,
71: last_update_login = hz_utility_v2pub.last_update_login,