APPS.HZ_MERGE_PKG dependencies on HZ_WORK_CLASS

Line 2026: 'HZ_WORK_CLASS', 'HZ_EMPLOYMENT_HISTORY',

2022:
2023: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2024: p_to_fk_id, p_par_entity_name,
2025: 'HZ_MERGE_PKG.work_class_merge',
2026: 'HZ_WORK_CLASS', 'HZ_EMPLOYMENT_HISTORY',
2027: 'WORK_CLASS_ID', 'EMPLOYMENT_HISTORY_ID', x_return_status);
2028:
2029: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2030: l_dup_exists := HZ_MERGE_DUP_CHECK.check_work_class_dup(

Line 3940: UPDATE HZ_WORK_CLASS

3936: BEGIN
3937:
3938: IF (x_to_id <> FND_API.G_MISS_NUM AND
3939: x_to_id <> p_from_id) THEN
3940: UPDATE HZ_WORK_CLASS
3941: SET
3942: STATUS = 'M',
3943: last_update_date = hz_utility_pub.last_update_date,
3944: last_updated_by = hz_utility_pub.user_id,

Line 3953: UPDATE HZ_WORK_CLASS

3949: program_update_date = sysdate
3950: WHERE work_class_id = p_from_id;
3951: ELSE
3952: -- Update and set employment_history_id = p_to_fk_id where pk = from_id
3953: UPDATE HZ_WORK_CLASS
3954: SET
3955: employment_history_id = p_to_fk_id,
3956: last_update_date = hz_utility_pub.last_update_date,
3957: last_updated_by = hz_utility_pub.user_id,