[Home] [Help]
54: SET requested_by_id = p_to_fk_id
55: WHERE requested_by_id = p_from_fk_id;
56: END IF;
57:
58: IF p_entity_name = 'AMW_AP_EXECUTIONS' THEN
59: UPDATE amw_ap_executions
60: SET executed_by = p_to_fk_id
61: WHERE executed_by = p_from_fk_id;
62: END IF;
55: WHERE requested_by_id = p_from_fk_id;
56: END IF;
57:
58: IF p_entity_name = 'AMW_AP_EXECUTIONS' THEN
59: UPDATE amw_ap_executions
60: SET executed_by = p_to_fk_id
61: WHERE executed_by = p_from_fk_id;
62: END IF;
63: